Removing Security Completely

[julostarr]

I'm using Access 2003.

I set up security for my database on a shared network, which has worked fine
so far. I set it up to apply security to all databases, but now someone is
having a problem. I would like to go back to apply the security to just this
database.

Is there anyway of doing this? If not, how to I remove the security
completely to start over without causing problems?

The first thing I tried was to delet the security file completely, but then
I was not allowed access into the database at all. IT did a restore for
those files to get us back to were we started, but I still need to change the
security problem because others are not able to get into their personal
computer databases because the security is being applied to all.

 

[Olduke]

I'm using Access 2003.

I set up security for my database on a shared network, which has worked fine
so far. I set it up to apply security to all databases, but now someone is
having a problem. I would like to go back to apply the security to just this
database.

Is there anyway of doing this? If not, how to I remove the security
completely to start over without causing problems?

The first thing I tried was to delet the security file completely, but then
I was not allowed access into the database at all. IT did a restore for
those files to get us back to were we started, but I still need to change the
security problem because others are not able to get into their personal
computer databases because the security is being applied to all.

This is a Workgroup File problem as covered in your previous post in General
Questions.
Each "secured" database requires its own workgroup file.
Set up a new workgroup file for just this database.

 

[Keith Wilby]

I'm using Access 2003.

I set up security for my database on a shared network, which has worked
fine
so far. I set it up to apply security to all databases, but now someone
is
having a problem. I would like to go back to apply the security to just
this
database.

If you've done it correctly then this will already be the case. You and
your users need to stay joined to the default "system.mdw" workgroup and
join your custom one on a session-by-session basis using a desktop shortcut.
See the example on my web site for more info.

Is there anyway of doing this? If not, how to I remove the security
completely to start over without causing problems?

To remove security, grant full permissions to all objects to the "Users"
group then import all objects into a new mdb file.

The first thing I tried was to delet the security file completely, but
then
I was not allowed access into the database at all. IT did a restore for
those files to get us back to were we started, but I still need to change
the
security problem because others are not able to get into their personal
computer databases because the security is being applied to all.

All sessions of Access require a workgroup file.

Keith.
www.keithwilby.com

 

[Tom van Stiphout]

On Wed, 5 Mar 2008 12:37:07 -0800, julostarr

It seems you are a hacker, and did not follow the often given advice
to first download, study, and fully understand the Security FAQ from
microsoft.com. Workgroup security is an advanced topic and you cannot
guess how it works or you'll get in deep trouble.

-Tom.

 

[julostarr]

I am not a hacker. I created this database, but it is the first time I have
done so and security is pretty new to me. I have looked at all I can on
Access 2003 help and I was trying to get advice to see if there was another
way of fixing this that I hadn't found. I have been working with the IT
person in my office on this, but I know more about Access than she does. I
figured it out on my own. Thanks anyway.

 

[julostarr]

Thanks for your help. I actually ended up using my .bak file to restore.
Since it was created last Wednesday it wasn't that big of a deal, but I will
do this if I have that problem again.

Could you answer another question for me? On using Security Wizard, do you
know what the difference is between these two questions:

"I want to make this my default workgroup information file."

&

"I want to create a shortcut to open my security-enhanced database."

 

[Keith Wilby]

Could you answer another question for me? On using Security Wizard, do
you
know what the difference is between these two questions:

"I want to make this my default workgroup information file."

&

"I want to create a shortcut to open my security-enhanced database."

I've never used the wizard but I'm guessing that answering yes to the first
one will join you to your custom workgroup by default. I would not
recommend doing this. Choose the other option.

Keith.

 

[Keith Wilby]

I have looked at all I can on
Access 2003 help

As you have found it is woefully inadequate. There's a link to the FAQ on
my web site.

Keith.
www.keithwilby.com

 

[Tom van Stiphout]

On Thu, 6 Mar 2008 06:16:03 -0800, julostarr

Sorry if my words were a bit strong.
But you have proven that you tried to apply security without reading
this FAQ, and that's just flatly impossible. You *have* to study the
FAQ first.
It is unfortunate that the security options (even a wizard) appear in
the menu structure just like any other innocent menu option, so why
not click-click try some things? At least in A2007 MSFT came to its
senses and removed this type of security (albeit likely not for this
reason).

-Tom.