permissons

  • Thread starter Thread starter grahamswindon
  • Start date Start date
G

grahamswindon

I run a few databases on stand-alones. I was trying out some of the
options using the permissions wizard, etc - and now all of the
databases on the computer (including new ones) require a logon.

This is a real pain as my students sometimes use the machine. Is there
any way that I can remove the need for permissions and hence log ons?
 
You have joined the computer to a workgroup information file (.mdw) that has a password set for the Admin user.

Access uses security out of the box. It ships with a mdw called system.mdw and silently logs you in as the Admin user. Every session of Access uses some mdw file. One is set as the default to use, unless you specify a different.

You don't mention the version, but if 2002/2003 then open Access and go to Tools, Security, Workgroup Administrator and see what mdw you are currently joined to by default. Click on join, and rejoin the system.mdw that ships with Access (you might want to search your computer (including hidden and system folders) first). Once you've set system.mdw as the default, you can then create a desktop shortcut to launch your secure mdb. Its target would have the following in it:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

The /wrkgrp switch will over-ride the default mdw for just that session of Access.
 
Back
Top