"Code Signing Certificate" with "split database"

[elgin]

I have a split Access 2003 database. I have signed the database with a
Code Signing Certificate from Small Business Server. This works fine
and users can have Access macro security on high or medium and do not
get prompted at startup.

The problem comes because there are two of us modifying the code.
Whenever either one of us changes the code, one of us must resign both
the front and back end of the database. If we forget to sign both, we
hear about it in the morning!

If we remove the digital signatures and set macro security to low, the
users get prompted about "Unsafe expressions".

Any ideas on the best way to handle this?

Thanks,
Elgin

['69 Camaro]

Hi, Elgin.

If we remove the digital signatures and set macro security to low, the
users get prompted about "Unsafe expressions".

Any ideas on the best way to handle this?

Have the users open Access and set the Macro Security to Medium, then close
the dialog window, then set the Macro Security to Low again. When they
receive the following message:

"Unsafe expressions are blocked. You can configure your computer to allow
all expressions to be evaluated. Allowing all expressions to be evaluated
affects all users on this computer. Do you want to allow the evaluation of
potentially unsafe expressions?"

.. . . tell them to press the "No" button this time.

Also tell your users to ensure that their antivirus software definitions are
up to date at all times so that they can check any incoming Access database
files for viruses, and to regularly check the network and the workstations
for viruses to find any files that may be infected. As long as they follow
this policy and don't open Access database files from strangers, the Access
Macro Security level can remain at Low on each workstation, and database
files won't need to be digitally signed to avoid the warnings.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[Tony Toews [MVP]]

elgin <sf*******@hotmail.comwrote:

>I have a split Access 2003 database. I have signed the database with a
Code Signing Certificate from Small Business Server. This works fine
and users can have Access macro security on high or medium and do not
get prompted at startup.

The problem comes because there are two of us modifying the code.
Whenever either one of us changes the code, one of us must resign both
the front and back end of the database. If we forget to sign both, we
hear about it in the morning!

I'm a bit puzzled that you'd have to sign the code in the backend.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/