Access 97 and Access 2002 on the same computer

[Nicolas Fortin]

Hi everybody,

I have on the same computer, Access 97 and 2002 (from Office XP) that are
both installed. When I launch an application with Access 97, I got the
following compilation error (it is a French to English translation) :

"Function or interface mentioned with restriction or the function uses an
automation title not managed with Visual Basic."

and it breaks on this line :

set rst = CurrentDb.OpenRecordset("...")

In fact, it seems that Access 97 does not recognize the CurrentDb object,
because when I enter it in the code editor, I get an invalid statement
error.

Also, when I type "Application" + <dot>, Access 97 crashes and the Microsoft
bug report window launches.

I do not see any missing references and I am using DAO 3.6 library. I simply
don't know what to do. Do you know what is wrong ?

Any suggestion would be appreciate,

Best regards,

Nicolas

 

[John Vinson]

I do not see any missing references and I am using DAO 3.6 library. I simply
don't know what to do. Do you know what is wrong ?

That's probably the problem. 3.6 is the version of DAO used in A200x.
A97 expects the DAO 3.51 library.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps