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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chris - 14 Mar 2007 08:46 GMT

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.

Reply to this Message

Allen Browne - 14 Mar 2007 09:00 GMT

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"

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How do you stop a user from double-clicking on .ACCDB file of 2007 and
> being able to see the tables' and queries structure ?
[quoted text clipped - 9 lines]
> Till 2003 this could be avoided wtih system.mdw and defining a
> password for Admin user.

Reply to this Message

chris - 14 Mar 2007 09:14 GMT

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"

Reply to this Message

Allen Browne - 14 Mar 2007 09:29 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks Allen for your message.
>
[quoted text clipped - 6 lines]
> "C:\Program Files\Microsoft Office\Office12\msaccess.exe"
> "C:\MyFolder\MyFile.ACCDB"

Reply to this Message