VBA problem -> multiple versions of Acc on 1 PC

[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 external users use Access 2003 so I have to
downgrade an application in version Access 2010.

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

Thanks a lot for any support on this !!

grtz
nic

[NoellaG]

Hi,

it's a known issue that a mix of several versions on the same computer (especially a mix of versions before 2007 with 2007 or higher). I didn't found a fix so far. I just change the code in the higher version, but keep the app in the lower version. It should work fine on the users PC.

success
NG

[ajetrumpet]

the only people at MS that can help you are the ones that have to be paid for, and they are extremely expensive, and will naturally not give any brain power effort to solve the problem unless you ask specific questions.

That is almost an assumption, but I know lots of people that work either directly or indirectly for MS, and every one of them say that they're miserable. Lower levels like call centers are even worse.

But that aside, adding to Noella, did you know that default references in the vbe are for the access version number you've opened the file with? I'm almost 100% on that. That's a serious problem, and one that has no answer because it will never be justified to research.

Moreover, having 2010 on your machine ALONE, and worse yet with other versions at the same time, will more than likely corrupt files. The reason is because 2010 introduces many features that earlier versions don't have, or can't implement or execute. In addition to this, 2010 has added a few new system tables that are required that aren't in earlier versions.

[nic02]

It's not logical at all!
My access apps works fine, they only don't work on my pc where Access 2010 is installed.

If I want to prepare an app in Access 2003, I have to change computer.
Again: it's not logical at all!

A fix? Anybody?

[ajetrumpet]

speaking professionally, the best thing you can do is get rid of all versions but one, and it doesn't matter which version it is.

people that don't know what they're talking about would try to find a fix. professional people would more than likely say the same thing that I just said. It doesn't matter if the files work now. The method you're using is not practical.

and no, I don't have a solution for this, as I don't do it. but good luck with it!

[nic02]

tx for your reply Adam and Noella!

It has nothing to do with new functions in Acc2010.
My apps are all written Acc2003 combining tables, queries, forms and lots of VBA code behind my forms.
I can open them in Acc2010 and all works fine. Without changing anything to my app, the VBA code won't work if I open them in Acc2003 on the same machine.
I simply have to sit down behind an older computer, grmbl.

I guess I have to experiment with my VBA references.

[ajetrumpet]

I unsubscribed from this because of this: http://www.access-programmers.co.uk/...d.php?t=204960

but what's even funnier about this thread is that I just added a section of a FAQ here about cross posting.

sorry...good luck bud! FYI, check your other thread, as more knowledge of 2010 is likely to be found over there. It's been around longer. Later!

[NoellaG]

I have to agree with AJ there. be practical about it. I just keep the highest version, and if needed I convert the file to a lower version. Of course it's best if you can check the converted version on the users PC, but up to now (please God, this is not a challenge.....) I didn't have any problems with that working method.

success
NG

[nic02]

I think I'm professional.
We deliver work for external people who don't always have Access 2010 of Access 2007.
If I make an Access programm for them to work home, how can I test if it will work for them?

So professionally, I do need several versions on 1 PC.
And that was no problem so far. After installing Office 2010, IT BECAME a problem.

Sorry for my language but I'm really getting tired of this.

[thhui]

Another way workaround is to use virtual box to install a new virtual window that has only access 2000, xp, and 2003.

You can then use access 2003 and access 2010 on the same machine but on different os.

[nic02]

OK, thanks for your answers all.
I will search further info about virtual box.

Access is a wonderful piece of software but now I know why professionals avoid it.

[nic02]

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

Solution is:
http://allenbrowne.com/bug-17.html

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