Access 2003 and 2007 on same PC - problem with VBA References

[JodieM]

I have Office 2003 and Office 2007 installed on the same PC (installed
correctly as per the KB article http://support.microsoft.com/default.aspx/kb/928091).
I am having problems with VBA References.
A new database created in Access 2003 contains references to the
Microsoft Access 12.0 Object Library, not the Access 11. Therefore
none of my VBA code will work. it comes up with an error of "object or
class does not support the set of events"
Does anyone know how to re-set the reference back to Microsoft Access
11.0 Object Library - I can't untick the reference to 12.0 and when I
browse to the 11.0's .olb file it does not replace it.

 

[Allen Browne]

If this is on Windows Vista, see:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

 

[JodieM]

If this is on Windows Vista, see:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

--
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.






- Show quoted text -

Allen you are a Legend!!!! I used the run as administrator option and
it works perfectly!!!! (so what if I have to press the UAC each time -
it works!)

Thank heaps for your help.

JodieM