Issues with Access 97 after Office 2007 is installed.

[PuddinPie]

Wondering if anyone else has run into this issue before? All computers have Access 97 installed and Office 2003. Recently we started updating just office to 2007 and leaving Access at 97. After Office 2007 is installed Access 97 looses its references and errors out on built in stuff, for example Data(), Left(), Right(), etc.

I've tried to re-register the DLL files and I’ve also tried the MS article http://support.microsoft.com/kb/194374 that tells you how to create module and a check/fix for references. I also did the whole Tools>References> and checked for missing references. Removed the ones that were there and re-added them.
Still getting errors.

The actual error is. "The expression On Load you entered as the event property setting produced the following error: Function isn't available in expressions in query expression 'Date()'"

It works fine for people who are running runtime which gets installed into different folder so I know the coding is correct.

Any ideas?

 

[boblarson]

You should NOT be running Access 97 with Access 2007 installed on the same machine. AND you should NOT be running the same database file as anyone else. Users should have their OWN COPY of the frontend (yes, it all needs to be split). Otherwise it is going to cause a major meltdown.

If you are using the same database files, which is not good, then EVERYONE should be upgraded at the same time. Nobody should be on a different version than anyone else.

 

[gemma-the-husky]

I wouldn't go quite as far as saying never. you can have A97/A2003 on the same machine as A2007, but when you switch from one to the other you can get a re-installation

However, when you installed A2007/Office 2007 you needed to select to keep previous versions.

Also, it may be a references problen. Which references are now checked in the A97 databases?

 

[boblarson]

I wouldn't go quite as far as saying never.

Never said never, but...

you can have A97/A2003 on the same machine as A2007, but when you switch from one to the other you can get a re-installation

Yes, you can have it. Is it wise - not really.

However, when you installed A2007/Office 2007 you needed to select to keep previous versions.

Yes, that would let it install together. And I've run 2003 and 2007 together on the same machine. However, I wouldn't open the same file with both if there are references set as it will honk things up.

Also, it may be a references problen. Which references are now checked in the A97 databases?

Yes, it is likely a reference problem. But if they run the same file from multiple versions of Access they are going to keep having the references problem until they don't do that any more and each person has their own copy of the front end file. Because a later version of Access will ALWAYS upgrade the references to the version that is running it if the references are from a previous version of the program (so like if you have an Excel reference it will upgrade them to Excel 14.0 Object Library when opened by Access 2007) and it will NOT set them back if the version opening it AFTER the later version has already opened it, and therefore suffer the reference problem. The people on Access 2007 would never see the problem but the users on Access 97 would each time they opened it up if a user with Access 2007 opened it up before them.

 

[PuddinPie]

Like I had sadi though. I only have Access 97 installed on the machine and Office 2007. That means that only outlook, excel, word and power point are installed as 2007. We are not running the extended Office 2007 versions so access 2007 is not installed.

What is installed is:

VB for Applications
MS Access 8.0 object library
MS DAO 3.51 object library

 

[boblarson]

The error is still a reference error and most likely has to do with the DAO version. You might be able to fix it on the computers having the problem by opening the database and going to the references and then unchecking the DAO reference and then closing the dialog and then reopening the references dialog and rechecking the DAO 3.51 reference.

 

[gemma-the-husky]

those refs are all i have in A97 apps.

are any showing missing? try changing the DAO3.5 to DAO3.6. That may help