Migration to A2002: data access methods unknown !

[Balex]

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

 

[Douglas J. Steele]

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.

 

[Aaron Kempf]

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