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.

 

[OldManEd]

Didn't work. Are you sure you are giving me directions for Access2007? Also,
I still have WindowsXP, SP2 and later.

Not clear what is meant by 'Chose Groups, and then User Group' It looks more
like an either/or choice, not group 'AND' User Groups. What is the
difference between Groups and User Groups???

I change the 'owner' to 'admin' instead of 'ed'. I did this for every object
in database.

The import procedure failed because it still said I didn't have permissions.

Ed

 

[Joan Wild]

Didn't work. Are you sure you are giving me directions for Access2007?
Also, I still have WindowsXP, SP2 and later.

Not clear what is meant by 'Chose Groups, and then User Group' It looks
more like an either/or choice, not group 'AND' User Groups. What is the
difference between Groups and User Groups???

Beside 'List:' select Groups
Then in the list box above that select 'Users'

(it is confusing in Access because of the multiple similar names - Admins
Group, Users Group, Admin User

The import procedure failed because it still said I didn't have
permissions.

As I said you need to grant the permissions to the Users Group

 

[OldManEd]

Joan,
Thanks. I solved my problem in a different, much simpler way. I found the
User-level Security Wizard and simply gave myself and 'admin' full
permissions for every object. in that particular database.
Ed

 

[Joan Wild]

OK, but you should create a new database and import all objects - this will
ensure that 'Admin' owns the database object and it is truly unsecured.

--
Joan Wild
Microsoft Access MVP

Joan,
Thanks. I solved my problem in a different, much simpler way. I found the
User-level Security Wizard and simply gave myself and 'admin' full
permissions for every object. in that particular database.
Ed