469,645 Members | 1,514 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

Really confused about Digital Certification for Access Apps. Advice?

The more I look at the issue of digital certification for our Access
app, the more confused I get. The SelfCert feature that allegedly
installed with Office 2003 does not work. The entry is on my menu but
is marked "invalid". I've tried re-installing it several times to no
avail.

In any case, Self Certification won't cut it for us. I MUST get the
security warnings to go away -- permanently! My understanding is that
full blown PAID certification is the only way to do that -- correct?

Can anyone out there point me to the best possible certification
authority for doing this for Access apps. I need a company that
speaks English, has LIVE customer support and has reasonable prices.

Thanks tons for all responses.

-- LW
Jan 22 '06 #1
5 2044
Forget this and set Macro Security to Low this "feature" is almost
completely useless and can be reset by updating the registry with the
following.

Software\Microsoft\Office\11.0\Access\Security" "Level" "1"
Root: HKLM; Subkey: "Software\Microsoft\Jet\4.0\Engines"
"SandBoxMode"; "2"

Slainte
Craig Alexander Morrison

Jan 22 '06 #2
The registry settings when applied using the PDW are
ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001


Jan 22 '06 #3
On 22 Jan 2006 00:12:21 -0800, "Craig Alexander Morrison"
<de*******@cdatagroup.freeserve.co.uk> wrote:
The registry settings when applied using the PDW are
ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002
No problem setting this one.
ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001


Hmmm. For some unknown reason, I have no Key call "Security" at the
"Software\Microsoft\Office\11.0\Access\ registry path. When I open
RegeEdit and create it using "Add > Key" and then edit it, the edit
form will not allow me to add a name for the item. What am I missing
here?

Obviously, I must ultimately do this with VBA code on startup,
correct? I'm sorry to admit that I still don't have much experience
manipulating the Registry -- with or without VBA code.

Anyway, thanks for your response. Any further advice you can offer is
most appreciated. If I can be of any help to you, please ask.

-- LW
Jan 22 '06 #4
On the Access 2003 menubar select Tools, Macro, Security and select the
Low setting on the dialog box this will set the Security key value.

Jan 22 '06 #5
> security warnings to go away -- permanently! My understanding is that
full blown PAID certification is the only way to do that -- correct?
No, the full blown certification is invalidated when you make
certain changes to the database. Common code practice like
updating the SQL in a stored query will invalidate a certificate.

With Self Certification, you can update the queries and the
mdb stays certified.

Just think of Access Security as a way to protect SQL Server,
and encourage people to switch from Access to SQL Server.

(david)

"Lauren Wilson" <no****@nospam.com> wrote in message
news:56********************************@4ax.com... The more I look at the issue of digital certification for our Access
app, the more confused I get. The SelfCert feature that allegedly
installed with Office 2003 does not work. The entry is on my menu but
is marked "invalid". I've tried re-installing it several times to no
avail.

In any case, Self Certification won't cut it for us. I MUST get the
security warnings to go away -- permanently! My understanding is that
full blown PAID certification is the only way to do that -- correct?

Can anyone out there point me to the best possible certification
authority for doing this for Access apps. I need a company that
speaks English, has LIVE customer support and has reasonable prices.

Thanks tons for all responses.

-- LW

Jan 22 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by alecjames1 | last post: by
20 posts views Thread by patrick courant | last post: by
20 posts views Thread by GrahamJWalsh | last post: by
10 posts views Thread by BillCo | last post: by
2 posts views Thread by Stupid48 | last post: by
2 posts views Thread by antonyliu2002 | last post: by
5 posts views Thread by cypher_key | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.