Can't Dim db (1 Viewer)

Access won't let me ...

Dim db As database

Saying user defined type not defined. But it will let me...

Dim rs As Recordset

But won't let me...

Set rs = db.openrecordset

Presumably the last one is directly related to the the first.


DOes anyone know why this is happening, and more importantly how to fix it!

Thanks

Check for missing references and make sure you have Microsoft DAO *.* library ticked, in my version(A97) I have Microsoft DAO 3.51 Object Library.

Also, you may need to explicitly reference the library depending on the priority level, I suspect the ADO library takes priority in higher versions so this may work for you.

Dim DB as DAO.Database

Cheers Ian, that's done the trick.