Re: Removing Security

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
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
>
>"Jeff M" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
>news:1f7d01c53e96$35f03b80$a601280a@xxxxxxxxxx
>>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?
>
>
>.
>
.

Relevant Pages

  • Re: vbs script to launch secure Access database
    ... It's very difficult to get my method to work with a custom workgroup ... - standard wgf where Admin does not have a password; ...
    (microsoft.public.access.security)
  • Re: no login prompt
    ... I was pointing to the correct workgroup. ... > There is a built in user named "Admin." ... As long as it remains blank, there will be NO prompt for a user name ...
    (microsoft.public.access.security)
  • Re: Remove Password
    ... You say that he gets the prompt. ... then the database is not secured at all. ... workgroup where the ADMIN user has a password. ...
    (microsoft.public.access.security)
  • Re: user icons gone from welcome screen!
    ... Well, Patrick, I tried a password cracker, and it reported that the admin ... Safe mode does no better. ... Can't get to command prompt as it wants you to log on first. ... If you use an inexpensive external USB2 drive case or drive connector, ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Able to open secured database with default MDW
    ... Joan and David: I want to thank you both for your efforts to help me. ... The admin user can be in any other group in any other ... system workgroup that does have permission. ... All this and I can still get into the database directly when using ...
    (microsoft.public.access.security)