Security/Workgroup

[Lewe22]

Once i have created a workgroup file to secure my database and prompted access to ask for a password it is asking me for a password every time i try yo open any other access database. I only want to be prompted for the password for the secure database, what have i done wrong?

[ADezii]

I only want to be prompted for the password for the secure database, what have i done wrong?

You haven't done anything wrong. For non-secure Databases, you must use the Normal/Default Workgroup Information File.

[Lewe22]

Why does that prompt for a password?
I have other databases previously created that are now asking for passwords.

[Lewe22]

My new workgroup had become the default. To fix this i rejoined the default access workgroup System.mdw, found (in my instance) at:

D:\Documents and Settings\LEWAL02\Application Data\Microsoft\Access.

I then created a shortcut which would direct the user through my desired workgroup for each access sesion.

Something like...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\My Documents\Call Management DB\Database (FE) For Distribution\Call Management DB.mdb" /wrkgrp "D:\My Documents\Call Management DB\Workgroup File\Call Management DB Wrkgrp.mdw"

[ADezii]

My new workgroup had become the default. To fix this i rejoined the default access workgroup System.mdw, found (in my instance) at:

D:\Documents and Settings\LEWAL02\Application Data\Microsoft\Access.

I then created a shortcut which would direct the user through my desired workgroup for each access sesion.

Something like...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\My Documents\Call Management DB\Database (FE) For Distribution\Call Management DB.mdb" /wrkgrp "D:\My Documents\Call Management DB\Workgroup File\Call Management DB Wrkgrp.mdw"

Thanks for sharing your solution.

[NeoPa]

Indeed. You've found that setting an Access Workgroup database actually sets it as the default for the INSTALLATION of Access on that computer. NOT an individual database.

This, and various other aspects of Access security files, have been causing confusion in many for years. You have found a decent solution for your particular problem. Well done.