Removing Security

  • Thread starter Thread starter Jeff M
  • Start date Start date
J

Jeff M

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
 
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
-----Original Message-----
You have joined your newly created workgroup and are rightly being prompted
for passwords. You need to re-join the
Click to expand...
default "system.mdw" and only invoke
your custom workgroup using a shortcut in the format:

"Full path to MSACCESS.exe" "Full path to
Click to expand...
file.mdb" /wrkgrp "Full path to
 
Hi Jeff,

Jeff M said:
Keith,
When I attempt to access the system.mdw, I am prompted for
a user name and password.
Click to expand...

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.
I had setup a new Admin user
name (CUSTAdmin) and can certainly gain access to the
system.mdw,
Click to expand...

Again, I'm not sure what you mean by "gain access to the system.mdw"
but I do not know how to:

1) Re-join the default system.mdw, or
Click to expand...

Use the Workgroup Admin tool to browse to system.mdw and click the "join"
button.
2) Only invoke my custom workgroup using a shortcut in the
format you provided.
Click to expand...

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.

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.
Click to expand...
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
 
Back
Top