export security database

[florin]

How can I copy an security database on another computer?
On my computer, User permission run , but when I copy database (2002)
in another computer, database is opened without problem with full
permission.

Thanks

 

[Tom Wickerath]

If I understand you correctly (?), your secured Access application seems to
work correctly on one computer, with the associated workgroup information
file (*.mdw). However, when you copy just your database to another computer,
without the .mdw file, you are able to open it with full permissions. Is this
correct? If so, you have not secured the application correctly.

A common mistake is to fail to remove Admin from the Admins group (step 6 in
the list below). See Lynn Trapp's "The 10 Steps Summarized" list, here:

http://www.ltcomputerdesigns.com/Security.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[florin]

Correct. You understand exactly!

But, how can I "link" new workgroup file to the database ?
I rename new workgroup file (InfoGroup.mdw) and I open my
database without problem with system.mdw.
I have an insecured application?
How can I repeat the secured operation for my application?

 

[John W. Vinson]

Correct. You understand exactly!

But, how can I "link" new workgroup file to the database ?

You open the database and use Tools... Security... Workgroup Administrator to
Join the custom mdw file.

I rename new workgroup file (InfoGroup.mdw) and I open my
database without problem with system.mdw.
I have an insecured application?

Yes. You have an unsecured application. I suspect that you have left the
default Admin user in the workgroup file, with no password and full privileges
to everything.

How can I repeat the secured operation for my application?

Read Lynn Trapp's link, or the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully, all pages. Get a good night's sleep. Read it
AGAIN, even more carefully. Follow all the steps - I'd check them off one by
one on the printout. Near the end of the process it says to remove all the
privileges from the user named Admin - that's your problem.

John W. Vinson [MVP]

 

[Florin]

You open the database and use Tools... Security... Workgroup Administrator
to
Join the custom mdw file.


Yes. You have an unsecured application. I suspect that you have left the
default Admin user in the workgroup file, with no password and full
privileges
to everything.


Read Lynn Trapp's link, or the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully, all pages. Get a good night's sleep.
Read it
AGAIN, even more carefully. Follow all the steps - I'd check them off one
by
one on the printout. Near the end of the process it says to remove all the
privileges from the user named Admin - that's your problem.

John W. Vinson [MVP]

Thanks for all , but I REMOVE ALL THE PRIVILEGES FROM THE USERS NAMED ADMIN.
When try use named Admin , I don't open the application (it's OK!)
But...
I rename new workgroup file (for test) and I open my
application without problem with system1.mdw (access created automaticaly
files system1, system2, etc)
WITH USER NAME ADMIN.

Thanks and I wish you "a good night's sleep", John.