Re: How to remove Security from Access 2002

The wizard in 2002 created a backup of your mdb, before security was
applied. You'll find it in the same folder as your mdb, but it'll have a
bak extension. Just rename it back to have a mdb extension.

Open Access (no mdb) and go to Tools, Security, Workgroup Administrator.
Rejoin the standard system.mdw workgroup file. Do a search for it first
using Start, Search. Be sure to search hidden/system folders too.

The above will get you back to square one. For your other questions:
The webpage applies to all versions. Tools, Security, Permissions - select
the Groups option and then select the Users Group. Now grant full
permissions on everything.

You would have been better in step 2 to not make this workgroup file you
default. You want to leave your default as system.mdw and use a desktop
shortcut (which the wizard would create for you) to launch your secure mdb.

--
Joan Wild
Microsoft Access MVP

Marco Brilo wrote:
Hi all,
I was 'experimenting' with security in MS Access and quickly learnt
that it is something that needs lots of knowledge.. something I
lacked about the subject a few hours ago. I would greatly appreciate
some advice on removing the security I have inadverntly added to all
my databases.

I've looked at Joan Wild's website
(http://www.jmwild.com/Unsecure.htm) and found that amongst other
gold nuggets of information she posts how to solve my problem,
however I get stuck at step 3. 'Grant full permissions on all objects
to the Users Group'. I don't quite know how to set that in the
window.. my guess is Joan's help is for Access 2000.

I've looked through other posts and seems like people have had my
problem solved but for Access 2000 or earlier. Also I can't seem to
find the system.mdw on my hard drive, does 2002 version have this
file?

The databases are on a LAN that other users have access to as well.
The following steps is what I did to get to where I am now:
1. I Used the User-Level Security Wizard from Tools->Security
2. I chose "I want to make this my default workgroup information
file"
3. I went through the remaining steps creating myself and leaving the
current user in there as admin.

I have no problems accessing the database with the password I set but
the issue is that myself and every other user will have to login from
now on, something that we don't want. I would like the users to
simply open the database without a login screen.
What can I do go back to the way things were without any security?
Help please!!
Marco


.

Relevant Pages

  • Re: How to remove Security from Access 2002
    ... any security set up on my home MS Access databases so this one should be ... Just rename it back to have a mdb extension. ... Open Access and go to Tools, Security, Workgroup Administrator. ... Rejoin the standard system.mdw workgroup file. ...
    (microsoft.public.access.security)
  • Re: Office 12 Access Database Engine conflicts with DAO 3.6 librar
    ... the mdb I used to convert, this was already running in office 2007 and still ... I can see advantages to moving to accb secure encryption. ... Shame to lose workgroup security but like everybody else I just move ... succession planning and would rather work with SQL themselves because they ...
    (microsoft.public.access.modulesdaovba)
  • Re: Restore ownership
    ... wizard would have made a backup of your unsecured mdb. ... Tools, security, workgroup administrator and verify that you are currently ...
    (microsoft.public.access.forms)
  • Re: Use Level Security lockout
    ... MDW to open your database with some specialized permissions. ... see if I could use it to open the MDB with the correct credentials. ... Here are a number of links about security: ...
    (microsoft.public.access.security)
  • Re: Security wizard
    ... "Joan Wild" wrote: ... Once you have it secured, and tested, you should split the mdb. ... But don't split it until you have the security right. ... Microsoft Access MVP ...
    (microsoft.public.access.security)
Loading