I have been maintaining a few databases at work, most of them are in a 2003 format but we use them in Office 07. I have had no problem signing the 2003 format documents but I'm having trouble with the 2007 ones. I was told through our IT department that I have to go to the Publish feature and then package and sign, but that just gives me a .accdc document and I'm not sure what to do with it. Unfortunately our IT department only has documentation on how to digitally sign a 2003 document while using 2007 and that has been no help. Can anyone let me know what I'm doing wrong? Thanks

Quick question - why do you need to digitally sign it? You should be able to set the database location as a trusted location (http://www.btabdevelopment.com/ts/default.aspx?PageId=13) and then the code will run fine without user intervention.

When company first rolled out office 07 that worked but then they changed the security settings company wide that trusted locations don't work.

When company first rolled out office 07 that worked but then they changed the security settings company wide that trusted locations don't work.

This page explains it a bit (http://office.microsoft.com/en-ca/access-help/show-trust-by-adding-a-digital-signature-HA010234562.aspx), but as for the accdc file, it is just like the accdb file only digitally signed. You would use it in place of an accdb/accde file.

OK I have half of that down, I have packaged and saved the .accdc file. I have that saved on the network drive, where all users have access too it. So the way i understand it is I let the users know to open the .accdc file they have to extract it. So where do they extract the file too. And how will that affect multiple users in the database at the same time. Sorry I'm fairly new to access and I had this dumped on my plate.