secured database can be opened

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

Guest

I secured a backend database using the user-level security wizard, giving the
Users group read/execute permission on the database, but no permissions for
the other objects.
I am sure that Admin belongs to the Users group only.
On my computer, the situation seems ok, it blocks accessing the tables as
expected.
However, if I take this 'secure' database now to a different computer that
has no history of security, everyone can open not only the database, but all
the tables.
I do have studied the Microsoft white paper of 1995. The SECFAQ.doc seems
not to answer to my problem.
Any help is very much appreciated!
Best regards from Germany.
 
Michael said:
I secured a backend database using the user-level security wizard,
giving the Users group read/execute permission on the database, but
no permissions for the other objects.
I am sure that Admin belongs to the Users group only.
On my computer, the situation seems ok, it blocks accessing the
tables as expected.
However, if I take this 'secure' database now to a different computer
that has no history of security, everyone can open not only the
database, but all the tables.
I do have studied the Microsoft white paper of 1995. The SECFAQ.doc
seems not to answer to my problem.
Any help is very much appreciated!
Best regards from Germany.
Click to expand...

Is "Admin" still listed as the owner of the database and the tables? It should
not be. Owners have rights above and beyond the permissions granted them.
 
Thank you Rick,

Admin is not the owner of the database.

It seems that I have found the solution: After reading the MS Access
Security FAQ, I converted the file to Access 2003 format and did the steps as
described in point 1.10 in the FAQ. Since then it seems to be ok.
 
Back
Top