Dim db As Database does not compile

Bill (Unique as my name) · Jul 9, 2006

Dim db As Database ' Current DB

This does not work in Access 2000 VB. Is there a way around it?

Thank you.

'69 Camaro · Jul 9, 2006

Hi, Bill.

You need to add the DAO 3.6 Object Library as a reference. The Database
class is contained in this library.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Marshall Barton · Jul 9, 2006

And, unless you intend to use it, uncheck the ADO library.

Bill (Unique as my name) · Jul 10, 2006

AHA! So . . . once again Microsoft attempts world domination by not
anticipating my every blunder. Damn your DOS, Bill Gates!

'69 Camaro · Jul 10, 2006

You're very welcome. Glad you've got it working.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.