FindFirst

[Florin]

Hi,

I have an application in Access97 and use method FindFirst.
I want move application in Access2000, but method FindFirst don't exist.
What can I do?

Thanks

Florin

 

[Graham Mandeno]

Hi Florin

In Access 2000 MS decided that a new data access model was the was to go and
that the old one was for the scrap heap. Fortunately they realised their
mistake and turned things back again for Access 2002/3.

The "old" method is called DAO (data access objects). The "new" method is
called ADO (ActiveX Data Objects).

DAO and ADO both have an object called a "Recordset" but they have different
properties and methods. The DAO one has a "FindFirst" method but the ADO
one does not.

If you created a new database in Access 2000 and then imported your code
modules and forms, then the Visual Basic references in your project would
include ADO ("Microsoft ActiveX Data Objects 2.x Library") but not DAO
("Microsoft DAO 3.x Object Library").

Click on Tools > References in the VB window and uncheck "Microsoft ActiveX
Data Objects 2.x Library", then scroll down and check "Microsoft DAO 3.x
Object Library".

 

[Florin]

That's it!
Thanks, now is ok!

Florin
Bucharest, Romania