By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.