Avoid users being able to see db structure in .ACCDB of 2007

[Chris]

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"

--
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.
"Chris" <CL*****@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

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.