Access 2007 Permissions

[Anton]

I created a couple of Access Dbases for my colleagues to work with .
Is there any way that i close the accesabilty to the tables and queries in
order to have the dbase security .

Anton

 

[Douglas J. Steele]

If your Access 2007 database uses the new accdb file format, there's nothing
you can do: security was removed.

If it's still in the older mdb file format, you can apply Access User-Level
Security, exactly the same as in previous versions.

 

[Anton]

Thank you,
its a pity i used to use it in access 2000 ,,but now i am using access 2007
for new solutions . Dont understand why they took away these features .

Anton

 

[John W. Vinson]

A2007 still supports the A2000 and A2002/3 format .mdb files, and Workgroup
Security still works in those formats... so it's not altogether gone. What you
can't do is apply workgroup security to one of the newer .accdb format
databases.

One reason they took it away is that it provides a false sense of security.
It's pretty easy to find "cracks" on the Web, which can break into a database
with workgroup security: "Locks only keep out honest people". There is
probably NO file-based (like Access) system which can be made really secure.

A server-based system such as SQL/Server can be broken, too, but it's a whole
LOT more work for the criminal - all but prohibitive if the SQL security is
set up correctly and people take appropriate precautions with their passwords
and logons.

In addition, workgroup security was just *so* complicated that it was often
applied incorrectly, causing more problems than it solved.