New Error in modules

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

Guest

I have a database that I have been using for about a year. All of a sudden I
am getting a compile error on the following statement:

Dim dbs As Database

None of the references have changed. Any ideas?
 
Emily8 said:
I have a database that I have been using for about a year. All of a
sudden I am getting a compile error on the following statement:

Dim dbs As Database

None of the references have changed. Any ideas?
Click to expand...

Maybe the actual DAO360.DLL file has been changed or moved. Try opening
the References dialog, unchecking the reference to Microsoft DAO 3.6
Object Library, closing the dialog, reopening the dialog, locating the
reference, and re-checking it.

Note: if you're using Access 97, it would be the DAO 3.51 Object
Library.

It may also be that some other reference has been broken, and that's
keeping the DAO reference from being interpreted. Be sure to look for
any other reference marked MISSING while you're at it.
 
Thanks. That worked...

Dirk Goldgar said:
Maybe the actual DAO360.DLL file has been changed or moved. Try opening
the References dialog, unchecking the reference to Microsoft DAO 3.6
Object Library, closing the dialog, reopening the dialog, locating the
reference, and re-checking it.

Note: if you're using Access 97, it would be the DAO 3.51 Object
Library.

It may also be that some other reference has been broken, and that's
keeping the DAO reference from being interpreted. Be sure to look for
any other reference marked MISSING while you're at it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top