Created in 2000, can't open in 2003

[Lee Stafford via AccessMonster.com]

I really appreciate any and all help that I can get. I have created a db
in Access 2000 and I have a user that is trying to use it in 2003, but it
says they do not have the proper permissions. I should have never tried to
secure the db in the first place. It has only caused me troubles. Is
there anyway to get the db back to its original state so that my users can
open it using Access 2003 or XP?

Thanks again,

Lee

 

[Joan Wild]

I really appreciate any and all help that I can get. I have created
a db in Access 2000 and I have a user that is trying to use it in
2003, but it says they do not have the proper permissions. I should
have never tried to secure the db in the first place. It has only
caused me troubles. Is there anyway to get the db back to its
original state so that my users can open it using Access 2003 or XP?

Two possibilities:
1. Provide them with the mdw file that you used to secure it with, and give
them a desktop shortcut with a target of
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"
They should be able to use it fine.

2. If you really want to remove security, then open it in 2000 logging in
as a member of the Admins Group. Grant full permissions to all objects to
the Users Group. Exit Access. Use Start, Run, wrkgadm.exe to rejoin the
system.mdw workgroup that shipped with Access (it's usually in the
windows/system folder, but search for it first). Open Access 2000 (you
should get no login prompt), create a new mdb and import all objects from
your old mdb. This news mdb will be unsecured.