Setting up Certificate on Access 2007 Runtime workstations to avoid Security Notice with Frontend DB
Posted on 2008-10-25
I've done a bunch of reading on the security and cerficates used in Office VBA project but I'm still fuzzy on if I can get rid of the security notice:
"A potential security concern has been Identified"
Warning: trustworth source etc etc....
File Path: xxxx\xxx\
I have a split access 2007 operating only within my own domain (sbs 2003). Both the FE/BE are located on a 2003 memeber server that is mapped as drive J: on all the domain workstations (XP sp3).
Also possibly worth mentioning is I have written a small visual basic "launcher" that is located on each workstation and it looks into the J: folder where the FE is, checks the file name and runs the latest version of the FE. The file name contains the day and version like this: ProgramX_08.10.24.02.accdb
I have 4 workstation that are using the access runtime and these system put up the above security warning where system with full blown access (office 2007) do not. I think I can setup the certificate authority on my domain server and sign my FE so this security message does not appear? Or can I sign the FE using the Office VBA Certificate tool and export this certificate to the other runtime workstations. I've tried a lot of different ways of signing and importing certs etc that I have read about in various articles but no success.
I wouldn't might getting an actual cert for macro signing but it looks like they are $400 a year and that's a bit much since I don't distribute projects outside my company. I'm all for security but it seems we are damn close to not being able to run projects on our own computer as we are creating them. Thanks in advance.