I have many Access databases that I have created for
personal use, and I recently created one for users to
input weekly info and print reports.  I created a
workgroup along with passwords to limit access, but now I
am prompted to input a password in every database I have,
including when I'm creating a new database.  How can I
make it so that only the 1 database needs a user name and
password to gain access?

You have joined your newly created workgroup and are rightly being prompted
for passwords.  You need to re-join the default "system.mdw" and only invoke
your custom workgroup using a shortcut in the format:

"Full path to MSACCESS.exe" "Full path to file.mdb" /wrkgrp "Full path to
workgroup.mdw"

HTH - Keith.
www.keithwilby.com

Show quoteHide quote

Keith,
When I attempt to access the system.mdw, I am prompted for
a user name and password.  I had setup a new Admin user
name (CUSTAdmin) and can certainly gain access to the
system.mdw, but I do not know how to:

1) Re-join the default system.mdw, or
2) Only invoke my custom workgroup using a shortcut in the
format you provided.

When I originally set-up my new workgroup, I set it up
through the Workgroup Administrator, then created a Custom
Admin, and disabled (removed) the Default Admin, per the
instructions provided in my Access guide.  Then, I noticed
that this process was for when you have no existing
databases, so I went back and removed the Custom Admin, re-
enabled the Default Admin, and set-up my workgroup using
the Security Wizard.  Currently, I have all the user names
(incl the Custom Admin) set-up, but I need to make sure
that the CUSTOMER db is the only db that requires special
access and that all other dbs, including any new dbs, will
not prompt me or my colleagues for user names and
passwords.

I apologize for my confusion and greatly appreciate your
help!!!  I am still reading my Access guide, as well as MS
Access Security FAQs and anything else I can get my hands
on.
Jeff M

rightly being prompted
default "system.mdw" and only invoke
file.mdb" /wrkgrp "Full path to
Show quoteHide quote

Hi Jeff,

What do you mean by "access the system.mdw"?  Are you saying that you're
joined to the default system.mdw but are prompted for a password?  If so
then the Workgroup Admin tool has been used to modify it.

Again, I'm not sure what you mean by "gain access to the system.mdw"

Use the Workgroup Admin tool to browse to system.mdw and click the "join"
button.

An example of this would be:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\MyFolder\MyFile.mdb" /wrkgrp "C:\MyFolder\MyWorkgroup.mdw"

This works for Office 2003 on drice C on XP Pro but other installations will
be similar.

<snip>

Try the step-by-step guide on my website but be sure to work on copies of
your files.

Regards,
Keith.
www.keithwilby.com

Jeff, as well as reading the FAQs etc., you really need to follow a
written list of explicit instructions - adding and omitting nothing.
It's virtually impossible to get it right by sequencing the steps
yourself.

HTH,
TC

Report of database object permissions
Security file not holding changes
Some users have to rejoin workgroup daily, why?
macro security error message
New to security have questions before plunging
how to secure a new db with an existing .mdw
DB Splitter err
Assign a workgroup to a workspace object - Thanks to Paul Overway
Opening MDB with and a workgroup file.
Workgroups & Distribution of my Application