Don't need security in Access 2007 or Access 2003

[OldManEd]

When I try to open a secure file (created in Access 2007) in Access 2003 I
get error 3033, 'You do not have the necessary permissions.......have your
system administrator ....." I AM THE ONLY USER AND, THEREFORE, AM AN
ADMINISTATOR!!!! How do I give permission to open this database???


I made a terrible mistake in Access 2007 accidentaly giving one of my
database applications some kind of a security lock. I have a file named,
"Security.mdw" Can I delete it to get back to a 'NORMAL' work
enviroment?????

Ed C

 

[Joan Wild]

Do not delete the security.mdw!

If you want to keep it secure, then create a desktop shortcut to open it in
2003...
"path to 2003 msaccess.exe" "path to secure mdb" /wrkgrp "path to secure
mdw"

If you really want to remove the security, then check the folder where your
mdb is located. Is there a file with the same name with a bak extension?

If so, rename it to have a mdb extension. See if you can open that in 2003.
*If* you can, then this is your unsecured mdb and you are safe to delete the
secure mdw.

 

[OldManEd]

No, don't think the .bak will work since I been using this data base with
its permission lock for a couple of weeks. I use it almost daily. Really,
really need to get rid of this 'feature' as I also share file with other
volunteers.
EdC

 

[Joan Wild]

OK, to get rid of security...
Open it, logging in as the user that is the owner. Go to Tools, security,
permissions. Choose Groups, and then Users Group.

Grant full permission to every object (including the Database object) to
this Group. Use the workgroup administrator to ensure you are joined by
default to the standard system.mdw that ships with Access.

Close Access. Open Access and create a new database (you should not have to
login). File, Get External Data, Import and import all the objects from
your 'secure' mdb - don't forget to click on Options (it may be Advanced)
and import the import/export specs and menus.

This new database is your unsecured mdb.