Office references

[John]

Hi

I have office 2000 installed but in references I see office 10. The rest of
the office apps are still 9.0. The problem is that when I send the compiled
access app to clients who have office 9, the app breaks. How can I get back
office 9.0 reference?

Thanks

Regards

 

[Allen Browne]

Hi John

1. Create a new (blank) database.
2. Check that it has the correct references.
3. Import everything from the problem database:
File | Get External | Import

I've only seen this happen once, when Access 2000 and Access 2002 were both
open at the time, and a new database was created in A2000. The connection
between the Access window and the VBA window seems so weak that it can
actually get confused by this situation. In my case the new A2000 mdb ended
up with a reference to the MS Access 10 library, and was totally useless.
Had to be recreated and everything imported.

(If you are actually referring to the MS Office library, and you don't need
it, you may be able to just uncheck the reference to dump it, but I image
the create'n'import would still be worth the effort just to be sure.)