secured database can be opened

29 Oct 2006 10:37 AM

Michael

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.

29 Oct 2006 11:29 AM

Rick Brandt

Michael wrote:

> 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.

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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

29 Oct 2006 7:32 PM

Michael

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.