Dave Page wrote:
>
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> >
> > Joseph Watson wrote:
> > >
> > > Here is my VB code:
> > >
> > > Private Sub Command5_Click()
> > >
> > > Dim FSEInfo As Workspace
> > > Dim conn As Connection
> >
> > If I remove the above line(Connection), the following
> > seems to work though I don't understand the reason.
>
> If it were VB I'd say in a flash that ADO is referenced in the project
> before RDO/DAO and conn was defaulting to ADODB.Connection. Is this possible
> in Access?
Oh I see.
Joseph, please change the line like
Dim conn As DAO.Connection
and try.
regards,
Hiroshi Inoue