Geeks With Blogs

News



Add to Google

Tim Hibbard CEO for EnGraph software

Having troubles running your Access 2000/XP apps on Access 2003? This is due to the new security settings in Access.

Update: Instructions for Access 2007

For the full version of Access:

Open Access 2003 from the start menu. Go to Tools->Macro->Security... (you may have to "reset" your toolbar if this menu does not show up. Tools->Customize->Toolbars Tab->Reset)

On the dialog box that opened up, select "Low", then click "OK"

For Access 2003 Runtime:

Set or create the following registry keys:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]

"SandBoxMode"=dword:00000002

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security]

"Level"=dword:00000001

If you need to keep your security settings at Medium or High, then you will need to obtain or create a digital signature for your application.

More information about signatures can be found here.

Posted on Saturday, August 21, 2004 7:39 AM MS Office | Back to top


Comments on this post: Access 2003

# re: Access 2003
Requesting Gravatar...
Thanks, I've been looking for awhile with no success trying to find a way to turn off macro securities for Access Runtime.
Your registry edits worked remarkably.
Now I can do an autoboot to a limited client into an Access runtime - totally unassisted.
My application rev change on the fly will now work because of this.

You totally ROCK!
Thank you.
Left by David Rowe on Sep 20, 2004 9:55 PM

# re: Access 2003
Requesting Gravatar...
Thanks for the tip, I will try it ASAP. If it works, it would be a real help
Left by Igor on Oct 27, 2004 1:08 PM

# re: Access 2003
Requesting Gravatar...
Ahhhh, at last!!!
Left by Strobel on Dec 01, 2004 7:36 AM

# re: Access 2003
Requesting Gravatar...
Excellent, Thank you ..
Left by System on Dec 13, 2004 5:03 AM

# re: Access 2003
Requesting Gravatar...
Wow, that has helped me greatly with a client deployment, great job!

Seems like the only option ultimately is to get a digital signature certifcate though, as otherwise the client machine security is comprimised :-(
Left by Tom W on Feb 28, 2005 4:04 AM

# re: Access 2003
Requesting Gravatar...
hi,

I have access 2003 installed on my system , when i try to install access 200o runtime it gives an error saying you need to have access 2000 installed on your system.

Please check and let me know

thanks in advance

Kunal
Left by kunal on May 12, 2005 2:28 AM

# re: Access 2003
Requesting Gravatar...
terrific! thx
Left by Rogers on Sep 06, 2005 7:18 PM

# re: Access 2003
Requesting Gravatar...
I came across this page looking for this solution. Thanks. I know nothing about Runtime (and the MS site isn't clear to me) so I thought I'd ask the knowledgeable... If an application is put together as a runtime package, can a user with full Access open it as a normal .mdb and make changes?
Left by dlrider on Oct 14, 2005 6:13 AM

# re: Access 2003
Requesting Gravatar...
I have a application write on access 2003 in mde format, how can I use it with out install ms access?
Left by c_o on Feb 15, 2006 10:21 PM

# How to enable security settings for ParaPlan
Requesting Gravatar...
With newer version of Access, Microsoft has modified how the security system works.  To make...
Left by EnGraph Software on Dec 15, 2006 10:32 AM

# re: Access 2003
Requesting Gravatar...
Is there any way to change security settings in Access 2007 without having to go into the application as you suggested ? i.e using registry settings similar to Access 2003.
Left by Thangam Moorthy on Feb 07, 2007 4:39 PM

# re: Access 2003
Requesting Gravatar...
Thanks for the Tip. I am currently using Access 2003, but If I buy the latest one will I be able to open 2003 Access aps on that ?

Thanks
Left by Michael Kors on Mar 09, 2007 6:52 AM

# Access 2003
Requesting Gravatar...
I need help severely. I have changed my security settings in my access database and now I cant get in. I dont even get a login prompt anymore I just get and error saying i dont have permissions to open the database. I think if screwed up my security.mdw and I need to fix it asap. Can I make it bypass the security.mdw?
Left by Kelly on May 31, 2007 7:48 PM

# re: Access 2003
Requesting Gravatar...
Praise the Lord, this problem has hunted me for weeks but your registry edit has been such a relief and I sincerely thank you
Left by Tim on May 05, 2009 9:38 AM

# re: Access 2003
Requesting Gravatar...
Thanks this worked!!
Left by Erik v Noort on May 28, 2009 7:57 AM

# re: Access 2003
Requesting Gravatar...
you are the man! was becoming such a problem on the network. now all is good! yay!
Left by joel on Mar 11, 2010 5:16 PM

# re: Access 2003
Requesting Gravatar...
You are genius man!!!
Thanks for the tutorial...
Left by Metta on Sep 25, 2011 10:39 AM

Your comment:
 (will show your gravatar)


Copyright © Tim Hibbard | Powered by: GeeksWithBlogs.net