469,275 Members | 1,314 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

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

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.

Mar 14 '07 #1
1 1787
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.
Mar 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

24 posts views Thread by el_roachmeister | last post: by
4 posts views Thread by ARC | last post: by
1 post views Thread by Cron | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.