New Error in modules

[Emily8]

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?

 

[Dirk Goldgar]

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?

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.

 

[Emily8]

Thanks. That worked...

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)