"unknown publisher" since installing SP2

[robjones23]

Hi all,

Our company is currently rolling out an SP2 update to all of our PC's and this problem has reared its head on all of the updated PC's so far.

Basically when someone opens a database from a shared drive, they get an error stating that the file was made by an unknown publisher (seems to be a security warning), they click ok and then can open the file fine.

However, once someone is in the database, if anyone else tries to open it on an SP2 machine, nothing happens, the double click the file and it refuses to open. If they open Access, then click file>open and navigate to the file, they can open it. They just can't double click the file.

People using the SP1 machines can open the database with no problems whether someone is already in the file or not.

I'm guessing this is something to dow tih the SP2 security measures.

To try to sort it out, I made myself a self signed digital ceritificate and signed my macros, thinking that once the macros were signed, it would then realise who had published the file.

The only thing this does is brings up a second notice (after the initial publisher message) which gives you the option to trust content from my signature. Once this has been done once, there's no need to keep trusting it but the publisher message still comes up.

I went into the database properties and under the custom tab changed the "publisher" value to my name "Rob Jones". This still didn't work and when the database is opened it still says it's an unknown publisher.

Does anyone know how to either turn off this check or publish a database?? I've tried google / MS but can't find anything on the subject.

Cheers,

Rob.

 

[robjones23]

Sorry to bump this but someone must know what the cause is?!

 

[ghudson]

This site appears to have your answer. Post back if this helps you. Unknown Publisher

www.UtterAccess.com has a few Microsoft employees trolling their forum.

 

[robjones23]

Thanks for taking the time to answer but this isn't the same message. The one I'm getting seems to be related to Windows XP SP2 security (It has the XP security icons etc as found in the control panel) rather than Access 2003 security. As the only thing that's changed is the introduction of SP2, I cannot see it being Access. Has no-one else seen this after installing SP2? I'm guessing it must be something to do with local policies on files, maybe it's been set in the build to use higer than default, I'm not sure.

 

[kyster]

I'm having the same problem with an xp SP2 machine here at work. My colleague gets the same message about security and digital signing. He can't open the database files that I email to him. Any help would be fantastic!

 

[Pat Hartman]

Make sure you have the latest version of Jet installed. Search for something called Sandbox mode (here and in the Microsoft kb) and see if that is the problem.

Please let us know how you resolve this issue.

 

[andres28]

error message

Hey try this

Open the Group Policy editor. Start > Run > gpedit.msc. Go to User Configuration > Administrative Templates > Windows Configuration > Attachment Manager. Enable the option "Inclusion list for low file types". Then add the .mdb file extension to the list. This is supposed to be for email attachments but it works for all the file types you list there. Let me know if this helped.

 

[Crystalit3]

Andres28 you are awesome

Andres28 - just wanted to say thank you, because your solution worked and got this 2 month monkey off my back. My company still does not know what changed to cause this to start happening to a whole department, but at least it is resolved. Thanks again!

Crystal