failing VBA code after installing Access 2010

[nic02]

Hi,

Last week I installed office prof 2010. My computer has several versions of
MS Access (2000, XP, 2003 and now 2010).
If I open an access application in a former version (Access 2003), my VBA
code won't work. I get error "object of class doesn't support event"

If I open the same app in Access 2010, no problem at all, everything works
fine.
If I open same app on another pc (without access 2010) in Access 2003,
everything works fine.
Do I have to add/delete a reference in VBA?

I need this because some users use Access 2003 so I have to
downgrade an application from version Access 2010 to Access 2003.

I called Micrsoft but they only assist in installingprocedure...

Thanks a lot for any support on this !!

grtz
nic

 

[MarkK]

Hey there and welcome.
Office products will advance references automatically but will not retreat them. If you have an Access 2003 database that references Excel 2003 and you open it in Access 2010 it will try to advance that Excel reference to Excel 2010. If it can it does, but if you now distribute that file to someone who only has Office 2003 on their system, that 2010 reference will not revert automatically back to Excel 2003.
Before you distribute the file you need to manually set those references back to the version of Office products that your users have.

 

[the_net_2.0]

lb,

he was answered hours ago on the MAF forum...as he posts multiple places to get an answer quickly/

 

[nic02]

@lb: do you have more detailed information about references, especially in VBA screen?
I had the same prob in the past and then I could mark some references so everything worked.

@the_net_2.0: sorry, I did not know that 'access-programmers.co.uk' and 'accessforums.net' were linked somehow. They don't look the same. And yes I posted on both forums, as well as on 'accessmonster', to optimise my chances because I'm tired to swith computer every time I want to check if our external people can work with my access programs.

I realise that my problem can not be solved immediately. I thought it was a known problem. I will experiment with VBA references and with virtual boxes. If I find a solution, I will post it rightaway.

 

[nic02]

Ok, my case is solved!!
Thanks to repliers in this thread, for all your efforts.

Solution is:
link die ik niet kan verzenden? Nogmaals poging= allenbrowne.com/bug-17. html
(zonder de spatie uiteraard)

option 2: create shortcut to start older version of Access, change shortcut in 'run as administrator' and everything works.