By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Really confused about Digital Certification for Access Apps. Advice?

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
> 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.