VBA References

  • Thread starter Thread starter Thorpe
  • Start date Start date
T

Thorpe

I have create a database that works fine, it is a multiuiser database used
by a number of colleges . I developed the Database on a windows XP with
Office XP.

When a user opens the Database on windows 2000 Office 2000 I get VBA errors
saying that the Microsoft Access 10.0 Object library cannot be found.

Now I guessed that this was because I set it to version 10 when I created
the database on office XP so I set the dataabse to use the object library
version 9.0, this was done on windows 2000 office 2000 ,everything worked.

The issue is that if I use my office Xp machine it will always reset the
library to version 10 is there no wauy to get it to use verison 9 all the
time so that I can develop on My Xp machine but users can stay with office
2000?

thanks in advance
 
Access 2002 can use its own native format or the 2000 format (shown in the
title of the Database window).

If you use the 2000 format with the Access 10 Object library reference, and
then open the database in Access 2000, it *should* automatically come up in
A2000 with a reference to the 9 library. The swapping should be completely
transparent.

On one occasion, I had A2003 and A2000 open at the same time, created a new
db in A2000, set the references, and later found the database was unusable
as it had a reference to the Access 11 library (which A2000 could not make
sense of). I've only seen that once, and put it down to the fact that I had
both versions open at once, so the loose coupling between the main Access
window and the VBA window came unstuck. Is this possibly what you
experienced?
 
Looks like you are correct.

I opened in Access XP and checked the references and it was set to Version
10.
I then closed Access down and opened it up on Access 2000 and the references
were now Version 9

I Database must have been open in both versions when the references broke, I
will have ensure no one uses the Database when I open up the database in XP.

Many thanks for your help much appriciated
 
Back
Top