Digital Certificate prevents opening

[Guest]

I have a secure multi-user Access 2003 database running on WinXP.
For all of the tables, only the Administrator has access.
For the queries, different groups are assigned different permissions.
The Security Level is set to Medium.
I didn't like the security warning when opening the database so I added a
Digital Signature using selfcert.exe.

This works fine when I open up the database as the administrator, no dialog
box appears anymore.

However when I login as one of the users belonging to another group I get an
error message that says "Microsoft Office cannot open mydatabasename.mdb due
to security restrictions. Security settings restrict access to the file
because it is not digitally signed."

Ironic isn't it? It only started to create this message after I DID give it
a Digital Signature!

Anybody have an idea how to solve this?? Thanks

Mark

 

['69 Camaro]

Hi, Mark.

However when I login as one of the users belonging to another group I get an
error message that says "Microsoft Office cannot open mydatabasename.mdb due
to security restrictions. Security settings restrict access to the file
because it is not digitally signed."

When you log in as another user, is this another Windows user account or
another Access user ID? If it's a different Windows user account, then make
sure that this other user's Macro Security level is not set to "High,"
because a self-certifying digital certificate is not acceptable as "valid"
at this level.

Is this Access database being accessed across a network or are these
multiple users all using the database from the same workstation? If the
users are accessing the database from across the network, then each of the
user's workstations will need to have that self-certifying digital
certificate in that computer's root store.

Ironic isn't it? It only started to create this message after I DID give it
a Digital Signature!

Now that a digital signature is assigned to the file, Access _must_ check to
ensure that it's a valid digital signature. Your database is failing this
check for some of your users.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)