dim dbs as gives no Database option

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top