G Guest Jan 20, 2006 #1 I have an Access database that has security set on it. I need to remove the security so that I do not have to log into it.
I have an Access database that has security set on it. I need to remove the security so that I do not have to log into it.
J Joan Wild Jan 20, 2006 #2 Log in as a user that's a member of the Admins Group. Give full permission to all objects (don't forget the database object) to the Users Group. Go into Tools, Security, Workgroup Administrator, and ensure that you join the standard system.mdw that ships with Access. Close Access, and then reopen it. Create a new database and import all objects from your secure database. This new mdb is unsecured.
Log in as a user that's a member of the Admins Group. Give full permission to all objects (don't forget the database object) to the Users Group. Go into Tools, Security, Workgroup Administrator, and ensure that you join the standard system.mdw that ships with Access. Close Access, and then reopen it. Create a new database and import all objects from your secure database. This new mdb is unsecured.
G Guest Jan 20, 2006 #3 THANKS! that did it. Joan Wild said: Log in as a user that's a member of the Admins Group. Give full permission to all objects (don't forget the database object) to the Users Group. Go into Tools, Security, Workgroup Administrator, and ensure that you join the standard system.mdw that ships with Access. Close Access, and then reopen it. Create a new database and import all objects from your secure database. This new mdb is unsecured. Click to expand...
THANKS! that did it. Joan Wild said: Log in as a user that's a member of the Admins Group. Give full permission to all objects (don't forget the database object) to the Users Group. Go into Tools, Security, Workgroup Administrator, and ensure that you join the standard system.mdw that ships with Access. Close Access, and then reopen it. Create a new database and import all objects from your secure database. This new mdb is unsecured. Click to expand...
