Tim Hibbard

Software Architect for EnGraph software
posts - 611, comments - 538, trackbacks - 469

My Links

News



Add to Google




Twitter












Tag Cloud

Article Categories

Archives

Post Categories

Image Galleries

EnGraph Blogs

Links

Other

Roll

Access 2003

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.

Print | posted on Saturday, August 21, 2004 7:39 AM | Filed Under [ MS Office ]

Feedback

Gravatar

# re: Access 2003

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.
9/20/2004 9:55 PM | David Rowe
Gravatar

# re: Access 2003

Thanks for the tip, I will try it ASAP. If it works, it would be a real help
10/27/2004 1:08 PM | Igor
Gravatar

# re: Access 2003

Ahhhh, at last!!!
12/1/2004 7:36 AM | Strobel
Gravatar

# re: Access 2003

Excellent, Thank you ..
12/13/2004 5:03 AM | System
Gravatar

# re: Access 2003

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 :-(
2/28/2005 4:04 AM | Tom W
Gravatar

# re: Access 2003

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
5/12/2005 2:28 AM | kunal
Gravatar

# re: Access 2003

terrific! thx
9/6/2005 7:18 PM | Rogers
Gravatar

# re: Access 2003

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?
10/14/2005 6:13 AM | dlrider
Gravatar

# re: Access 2003

Worked like a charm -- THANK YOU!
10/31/2005 10:44 AM | jeff
Gravatar

# re: Access 2003

I have a application write on access 2003 in mde format, how can I use it with out install ms access?
2/15/2006 10:21 PM | c_o
Gravatar

# How to enable security settings for ParaPlan

With newer version of Access, Microsoft has modified how the security system works.  To make...
12/15/2006 10:32 AM | EnGraph Software
Gravatar

# re: Access 2003

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.
2/7/2007 4:39 PM | Thangam Moorthy
Gravatar

# re: Access 2003

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
3/9/2007 6:52 AM | Michael Kors
Gravatar

# Access 2003

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?
5/31/2007 7:48 PM | Kelly
Gravatar

# re: Access 2003

Praise the Lord, this problem has hunted me for weeks but your registry edit has been such a relief and I sincerely thank you
5/5/2009 9:38 AM | Tim
Gravatar

# re: Access 2003

Thanks this worked!!
5/28/2009 7:57 AM | Erik v Noort

Post Comment

Title  
Name  
Email
Url
Comment   

Powered by: