How do you stop a user from double-clicking on .ACCDB file of 2007

[Guest]

How do you stop a user from double-clicking on .ACCDB file of 2007 and
being able to see the tables' and queries structure ?

If the solution is the database password, then database cannot open
from a shortcut as


"path to access 2007" "path to db 2007"


and user not able to open the database without needing to know the
password


Till 2003 this could be avoided wtih system.mdw and defining a
password for Admin user.


thanks a lot in advance.

 

[Allen Browne]

Using Access 2007, you can still create a shortcut to an MDB that includes
the /wrkgrp switch and MDW.

Just use include the full path to msaccess.exe, as in previous versions.
Example of Target for shortcut:
"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"C:\MyFolder\MyFile.mdb" /wrkgrp "C:\MyFolder\System.MDW"

 

[Guest]

Thanks Allen for your message.

What if in Access 2007 you use ACCDB. How do you stop your users from seeing
the tables' structure. Do you use database password ? If yes, then you cannot
create a shortcut and include the password also.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"C:\MyFolder\MyFile.ACCDB"

 

[Allen Browne]

User Level Security is overkill for most Access applications.

Just release an MDE to the end users so they can't modify the forms and
reports, or decompile/edit the code. Then set the properites of the MDE so
they can't hold down the bypass keys, or use special keys.