dim dbs as gives no Database option

[Guest]

When I open Access 2000 and go to a form and start writing code I begin with
"dim dbs as", and then the drop down dose not have the option of "database",
and I can go no further. The only solution seems to be to go to an old
instance which happily does work, clean out all that is there and begin with
that. I have tried repairing Office etc etc, and no success. Can anyone
help? Thank you.

 

[Sandra Daigle]

Check your references, chances are that you're missing the reference to the
DAO Library. Open the module in the Visual Basic Editor (VBE) then click
Tools->References. Make sure that the Microsoft DAO 3.x Object Library is
checked.

 

[Roger Carlson]

Database is a DAO object that is not in ADO. By default, Access 2000 only
has a reference to ADO. You'll have to set a reference to DAO in order for
it to work. See this link:
http://www.rogersaccesslibrary.com/References.htm

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L