Access, Vista and Event Procedures

[demosoc]

I have a (split) database created in Access 2003 on a shared network. Users with Vista (they're running Access 2007) are able to open the database and the forms, but event procedures (OnClick) don't run. I can open the event procedures and see them there, looking all ready to go, but Vista absolutely ignores them- not even an error message. There are no problems with the non-Vista users.

I've tried properties-> advanced-> run as administrator on the shortcut for the Vista/Access07 folks but that didn't work. Any ideas?

 

[Remou]

Have you tried self-certification and trusted locations?

 

[demosoc]

Thanks for the quick response Remou!

This is My First Database (homemade) and I'm not very versed in either of those processes. Is the purpose to remove security? If so, for just Vista users or for all of them?
Anyhow...
I've just tried to add the folder in which the database is stored to a Vista user's Trusted Locations and received the following error:

"The remote or network path you have entered is not allowed by your current security settings"

 

[Remou]

Did you follow:
"If you want to create a trusted location that is not local to your computer, select the Allow trusted locations on my network (not recommended) check box."

--

http://office.microsoft.com/en-us/help/HA100319991033.aspx

You may wish to consider self-certification:

http://office.microsoft.com/en-us/access/HP010397921033.aspx