Errors on Vista with Access 2002/2007 Installed

[Vic Spainhower]

Hello,

I have an Access 2002 Database that I'm trying to run under Ultimate Vista
and I'm having all sorts of issues. I might say this database works fine on
zn XP machine. The problem I'm having now is when it starts I have login
form that fails with :

The expression on click you entered on the event property setting produced
the following error: Object or class does not support the set of events.


I founnd a "Flaws in Mincrosoft Access posting by Allen Browne" that seemed
to fit this situation. I tried :

(1) Modified the permissions in the registry so as to run with full
permissions for users

(2) Tried "Run as Administrator" on a new shortcut to Access 2002

(3) Turned off User Account Control


Nothing has helped - I continue to get this error.


Any ideas???


Vic

 

[Allen Browne]

Firstly, go to:
Office Button | Access Options | Trust Center | Trust Center Settings
and add the folder where your database is to trusted locations.
The code will not run unless it is in a trusted location, or digitally
signed.

Next open any code window (e.g. press Ctrl+G) and go to:
Tools | References
Are any references marked "MISSING"?
For a list of the references you typically need for each version of Access,
see:
http://allenbrowne.com/ser-38.html

Once the location is trusted, and the references are correct, choose Compile
on the Debug menu. Fix any errors, and repeat until it compiles correctly.

 

[Vic Spainhower]

Firstly, go to:
Office Button | Access Options | Trust Center | Trust Center Settings
and add the folder where your database is to trusted locations.
The code will not run unless it is in a trusted location, or digitally
signed.

Next open any code window (e.g. press Ctrl+G) and go to:
Tools | References
Are any references marked "MISSING"?
For a list of the references you typically need for each version of
Access, see:
http://allenbrowne.com/ser-38.html

Once the location is trusted, and the references are correct, choose
Compile on the Debug menu. Fix any errors, and repeat until it compiles
correctly.

Allen,

Thanks for the reply, but I thought the "Trusted Location" was for Access
2007? I had already done this after converting the Access 2002 database to
2007 and it seemed to be working fine with the minimal testing that I had
done.

I removed Access 2007 from the Vista machine and the Access 2002 database
now seems to be ok.

So if the Access 2002 database must be in a trusted folder why does it work
when Access 2007 is not installed? There are no unresolved references. I
assume the "Trusted Folder" must only be required when both versions are
installed on the machine.

Vic

 

[Allen Browne]

Yes, the trusted folder stuff applies to A2007 only.

The issue must have been either references, or inadequate permissions to
write the registry.