Removing Security?

Hi,


I created an Access XP database, and then disabled all the menus that
allowed users to modify report design, etc... (I'll call them
administrative features). Users were only able to use record handling
options and the forms I designed. However, if I were to run the
database with a shift + double click, I would get the administrative
features again.

I didn't like this, so I tried to lock out the administrative features
by password protecting administrative access. I did this, but
unfortunately two problems resulted:

1) It is now impossible to access administrative features. When I run
the database, I am prompted with a password and all I see are the
record navigation options no matter how I ran the database. I can no
longer design reports, add forms, etc...

2) The password protection isn't a property of the database, but of
Access in general. If I run ANY database, I am confronted with the
same password protection. The other side of this is that anyone who
runs the database from a different machine is not subject to the
security settings I created.


I tried uninstalling and reinstalling Access (and the entire Office
XP) but to no avail. I read that a certain file was responsible for
Access security, but I could not find it.

Therefore, I have the following questions:

1) How can I re-acquire administrative features?

2) How can I remove this password?

3) How can I set a password for administrative access on a particular
database? I want regular users to get into the database without a
password, but one to be required when someone tries to gain access to
administrative features. This should be effective regardless of what
machine the user is on and should only be in effect for that database.



Thanks!

re: Removing Security?

<xmp333@yahoo.com> wrote in message
news:4a0da86b.0312110905.175614b0@posting.google.c om...

(snip)

[color=blue]
> 2) The password protection isn't a property of the database, but of Access[/color]
in general.

No, it is a property of the Workgroup Information File that is in effect
when you start that session of Access. There can be many different workgroup
files: all secured, all unsecured, or any mixture thereof.

[color=blue]
> If I run ANY database, I am confronted with the same password protection.[/color]

Only if you set security in the >default< workgroup file. What you should
have done, is to create a >new< workgroup file, & use that to secure your
database. You also use a shortcut to start the secured database. The
shortcut selects the correct workgroup file to use. By that means, your
secured databaase is fully secured, but no other databases are affected.

[color=blue]
> The other side of this is that anyone who runs the database from a[/color]
different machine is not subject to the security settings I created.

Then you did not do it properly.

You need to read-up on Access security. Google for the "Security FAQ". Read
it 50 gazillion times. Plan to spend at least a few weeks to get a basic
understanding of how to do it properly. Follow >all< the steps given, in[color=blue]
>exactly the sequence< they are given, adding & omitting nothing. Access[/color]
security is quite sophisticated. But it is tough to learn, initially.

HTH,
TC