Dimming a db

[loki]

I have a very stupid question I am sure. I am used to using Access 97 but I tried to use a recordset in Access2000 yesterday and ran into a problem. I usually do this "Dim db as Database" but that doesn't accept that in Access2000. Can someone tell me how to declare a database in 2000.

 

[Fornatian]

Explicitly specify the DAO library otherwise it is an ADO object.

Dim MyDB as DAO.Database

 

[boats02]

You may also need to add a reference to the DAO library in the Visual Basic Editor.

1. Enter the VB Editor.
2. Tools Menu and select "References"
3. Scroll down the list box and select "Microsoft DAO 3.51 Object Library"
4. Click "ok".

Now Access should recognize the DAO keyword.