When trying to convert a database from Access 2000 to 97 I get a message saying that at least one of the Microsoft Access97 object libraries are missing. I have tried changing and replacing the missing references in the Access97, but no luck. The only thing in my code that it does not like is "currentproject". One example is con = application.currentproject.connection Any suggestions on references or a replacement for currentproject?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reference problem when converting from 2000 to 97
- Thread starter evercall
- Start date
Evercall:
Is con defined as "Dim con As ADODB.Connection"?
If so, check that you have the references ADO 2.1 and DAO 3.6 (if I remember correctly). I think DAO must be before ADO, but try it both ways - whatever works. Good luck!
K. Hood
Is con defined as "Dim con As ADODB.Connection"?
If so, check that you have the references ADO 2.1 and DAO 3.6 (if I remember correctly). I think DAO must be before ADO, but try it both ways - whatever works. Good luck!
K. Hood
CurrentProject DOES NOT work in Access 97 as it was first released in Access 2000. Building a connection doesn't require you to use the CurrentProject.Connection property. It is only a crutch. You can set the connection property in the code using a string value for the connection.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------
- Status
Similar threads
- Locked
- Question
- Locked
- Question