Access 2003 and Vista 1

[ZOR]

I have someone complaining thir db does not work on a new PC using Vista. One of his comments is very similar to a posting I found on the internet which did not have an answer, any ideas??

Thread found:
Hello everyone,
I have an application that was developed using Access 2002-2003. It
runs just fine on my XP machine using Access 2003, as well as with the
2003 runtime. When I try to run it using Access 2003 on a Vista
machine, the opening screen - which has code in the On_Open event,
comes up with the error:

"The expression On Open you entered as the event property setting
produced the following error: Object or class does not support the set
of events"

I checked the references and there's nothing missing. The Access
reference is set to the 12.0 Object Library <- (I have 2007 installed
on this machine, so this is the newest). I am able to run the
application on the Vista machine using Access 2007. It tried starting
with a fresh new database and created a form with code in the On Open
event and got the same error - so it's nothing specific to this
particular application.

One more piece of information - I also have Access 2000 running on
this machine and when I create a test form with code in the On Open
event, I also get the error. The only time it runs successfully is
with 2007 (the db is still in the 2003 file format).

Anyone know what might be the problem and if there is a fix?

Thanks

 

[boblarson]

When you have multiple versions of Access installed on Vista, you need to set the MSAccess.exe files of each version to run as administrator. See my page here for how to do that:

http://www.btabdevelopment.com/main...ista/RunasAdministrator/tabid/87/Default.aspx

If, after setting that it still doesn't work, you can open the references again, uncheck the DAO reference, close the dialog and the database and reopen. That should jar it out of the problem. But, remember to set the run as admin first as you have to do that for multiple versions of Access on Vista.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[ZOR]

Many thanks Bob, very good. Have a star.

 

[boblarson]

Thanks!


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com