Thanks so much for all the help
I moved the DAO 3.6 up the reference list and this fixed the problem and it
works.
Thanks so much.
Joseph
----- Original Message -----
From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
To: "Dave Page" <dpage@vale-housing.co.uk>
Cc: "'Joseph Watson'" <jtwatson@datakota.com>; "'pgsql-ODBC (E-mail)'"
<pgsql-ODBC@postgresql.org>
Sent: Monday, January 28, 2002 4:55 AM
Subject: Re: [ODBC] Connection Problem
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
