Access97 and Access2000

[raindrop3]

Hello,

in Access97 I'm using this statement:
dim db as database

In Access2000 is doesn't work!

Does anyone know what the right statement is?

Thanks a lot.

Albert

 

[shacket]

That's the right statement. Your references are likely not correct or in the right order.

 

[Peter D]

First, use

dim dbs as DAO.database

You'll have to do the same with recordset objects.

dim rst as DAO.recordset

Then, make sure that "Microsoft DAO 3.x Object Library" is in your references list.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Shareware and Freeware http://www.peterssoftware.com

 

[raindrop3]

Thanks for the replys

I changed the order of my references and now it works great.

Thanks again,

Albert