Migration to A2002: data access methods unknown !

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Balex - 20 Feb 2007 23:31 GMT

Hi

I inherited an Access 2000 application that I split in a front end and
backend to use Oracle as a DB. To clean up years of accumulated code, and
because the app was crashing suddenly when connecting to the b/e, I created a
new Access DB and exported ALL objects (a lot of them) from the old front end
to the new one.

What I did not realize is that my new f/e is Access 2002, whereas the old
one was Access 2000.

First compile brings me loads of errors on data access methods that SHOULD
work, like .FindFirst, .Edit, .NoMatch, which I find hundreds of in the old
code. Suddenly, all these are not compiling any more ! It says "Method or
member not found" !!!

What's going on ? What am i overlooking here ?

Thanks for your help !

Balex

Reply to this Message

Douglas J. Steele - 21 Feb 2007 21:58 GMT

Neither Access 2000 nor 2002 have a reference set to DAO by default.
FindFirst is a DAO method, so I think it's a good bet that you need to add a
reference.

While in the VB Editor, select Tools | References from the menu bar, scroll
through the list of available references until you find the one for
Microsoft DAO 3.6 Object Library, and select it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi
>
[quoted text clipped - 20 lines]
>
> Balex

Reply to this Message

Aaron Kempf - 27 Apr 2007 21:12 GMT

of course, DAO hasn't been included with Office, Windows or MDAC for a
decade.. so maybe you should rewrite it as ADO

> Neither Access 2000 nor 2002 have a reference set to DAO by default.
> FindFirst is a DAO method, so I think it's a good bet that you need to add a
[quoted text clipped - 28 lines]
> >
> > Balex

Reply to this Message