secure.mdw

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ginger8990 - 23 Feb 2006 20:03 GMT

We have some users having MS access problem. They had a workgroup set up for
logging in MS access using a user ID and password for a particular
file.Recently they got office 2003 (it was office 2002 before). When I
changed security on Tools menu for MS access and join the workgroup using
secure.mdw, it changed all of MS access application, it asks password and
user ID for all of MS access documents. It didn't before. Do you know a way
to correct this? We only want one file with popup asking for user ID and PW
and not all files.

Many thanks!

Reply to this Message

Lynn Trapp - 23 Feb 2006 20:27 GMT

Ginger,
Your users should not join the secure.mdw file, but should join the default
system.mdw file that ships with Access. They should use a shortcut to open
the one database that is secured. The general syntax for the shortcut is:

"FullPathToMSAccess.exe" "FullPathToYourDatabase.mdb" /wrkgrp
"FullPathToSecure.mdw"

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

> We have some users having MS access problem. They had a workgroup set up
> for
[quoted text clipped - 9 lines]
>
> Many thanks!

Reply to this Message