problems with converting from access 97 to 2002

T

trace

try referancing the dao library. By default access 2000
and 2002 referance the ADO library, Access 97 was DAO.

open a module in design view and go tools\referances and
then choose the microsoft DAO 3.6 library. using the move
button move this selection above the ado library and then
click ok. now your db is referenced to the correct
library. Give it a try.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 12 Access Database Engine conflicts with DAO 3.6 library 14
Converting URLs in comments to Markdown-formatted links 2
Access 97 to Access 2000 3
user defined not defined 2
newbie problem with libraries and syntax 2
VBA Compile error when converting to Access 2007 4
Exporting from Excel to Access 2
Error with automation - Access 2007 creating Outlook calendar appo 1

Top