Un-doing Microsoft security setup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help
I was trying out the Access security features, and it's ruining all of my databases
All I want to do now is UN-DO that stupid security setup. In case you think I am an imposter who wants to hack into something, be assured that I have access to all of the security files and the passwords (since I created the databases). As a matter of fact, I am the only one that can get into these 5 databases now. Other users are now blocked...
HOW DO I REMOVE ALL OF THESE SECURITY FEATURES/SETUP???
 
----- TFerry wrote: ----

Help
I was trying out the Access security features, and it's ruining all of my databases
All I want to do now is UN-DO that stupid security setup. In case you think I am an imposter who wants to hack into something, be assured that I have access to all of the security files and the passwords (since I created the databases). As a matter of fact, I am the only one that can get into these 5 databases now. Other users are now blocked...
HOW DO I REMOVE ALL OF THESE SECURITY FEATURES/SETUP???

....and I need more than just "un-securing" the database. I want ALL of the security features un-done
 
TFERRY said:
----- TFerry wrote: -----

Help!
I was trying out the Access security features, and it's ruining
all of my databases! All I want to do now is UN-DO that stupid
security setup. In case you think I am an imposter who wants to
hack into something, be assured that I have access to all of the
security files and the passwords (since I created the databases). As
a matter of fact, I am the only one that can get into these 5
databases now. Other users are now blocked.... HOW DO I REMOVE ALL
OF THESE SECURITY FEATURES/SETUP???!
Click to expand...

Since you have the proper username/password, log into your database. Go to
Tools, security, permissions. Give all permissions to all objects (don't
forget the database object) to the Users Group.

Go to Tools, security, workgroup administrator and ensure you rejoin the
standard system.mdw workgroup (it's usually in the windows system folder).

Close Access, reopen it and create a new database. Import all the objects
from your database, and you should be set.
...and I need more than just "un-securing" the database. I want ALL
of the security features un-done!
Click to expand...

Sorry, that's not possible. Every session of Access uses security. It uses
a workgroup named system.mdw and silently logs you in as a user named Admin.
You can't run access without this.
 
I don't really need everything wiped out, I just want things back to where
they were a few days ago.

Then follow the steps outlined by Joan.
 
----- Lynn Trapp wrote: ----
I don't really need everything wiped out, I just want things back to wher
Click to expand...
they were a few days ago

Then follow the steps outlined by Joan

--
Lynn Trap
MS Access MV
www.ltcomputerdesigns.co
Access Security: www.ltcomputerdesigns.com/Security.ht


I followed all of the steps, but there is no option for "Tools / Security / Workgroup Administrator". I do not know how to "rejoin the System.mdw" file. I am using Access 2000 if that helps...
Ti
 
I followed all of the steps, but there is no option for "Tools /
Security / Workgroup Administrator". I do not know how to "rejoin
the System.mdw" file. I am using Access 2000 if that helps.... Tim
Click to expand...

It certainly does. The workgroup administrator in 2000 can be reached by
going to Start, Run and typing
wrkgadm.exe
 
----- Joan Wild wrote: ----
Security / Workgroup Administrator". I do not know how to "rejoi
the System.mdw" file. I am using Access 2000 if that helps.... Ti
Click to expand...

It certainly does. The workgroup administrator in 2000 can be reached b
going to Start, Run and typin
wrkgadm.ex

--
Joan Wil
Microsoft Access MV


Thanks Joan
I think I'll never use Access security again, but this has been a valuable lesson
Tim
 
Thanks Joan!
I think I'll never use Access security again, but this has been a valuable lesson.
Tim
Click to expand...

Tim,
I'm glad you got what you wanted. You shouldn't let the lesson you learned
be that you should NEVER use Access security, though. It can be a really
powerful tool, if implemented correctly. That's why Joan and I (and many
others who frequent this newsgroup) emphasize the need to follow the steps
in the Security FAQ to the letter -- without the slightest deviation.
 
Here I was struggling with a similar problem to TFerry and you ladies solved
it for me. Thanks a lot.

Background: An employee had been using Access for an accounting application
that used the system.mdw file located on a specific server. She also used
her copy of Access to build a few other DBs specifically for her department.
Accounting moved to a Terminal Server and took the original server offline.
Now she couldn't access her own files anymore, or even MSAccess for that
matter.

Using the tips I found here, as well as a copy of the original system.mdw
file, I was able to import all the objects into new databases. Thanks for
your help.

--
Best Regards,
Gerry

TFerry said:
Help!
I was trying out the Access security features, and it's ruining all of my databases!
All I want to do now is UN-DO that stupid security setup. In case you
Click to expand...
think I am an imposter who wants to hack into something, be assured that I
have access to all of the security files and the passwords (since I created
the databases). As a matter of fact, I am the only one that can get into
these 5 databases now. Other users are now blocked....
 
Back
Top