By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

Office references

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:41***********************@news.dial.pipex.com ...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.