Database on a LAN Drive, but security only works for me



Hi,

After several attempts at getting security working in access 2003, I
followed these procedures (from Joan Wild):

www.jmwild.com/AccessSecurity.htm

When I start access it prompts me for the user & password, but whenever one
of my colleagues open it from their machines it opens up straight away with
no password required.

I have:

- Created an owner user called super (this owns the DB and all objects)
- Created a new Workgroup file associated the DB to that
- Checked all users and permissions (especially Admin and User which have
none)
- Did the 'You can verify this by hitting Ctrl-G and typing
?DBEngine.SystemDB' and it says the DB is using the new workgroup I created

Where am i going wrong with this?

Cheers,
GLT.



.



Relevant Pages

  • Re: Adding a database to existing workgroup file
    ... Joan: Thanks for your patience. ... Administrator doesn't necessarily show the file in use, ... had privileges and then tried double-clicking the dbs themselves. ... It depends on what workgroup file you are joined to by ...
    (microsoft.public.access.security)
  • Re: Security loose ends
    ... Thanks again, Joan. ... I also noted the PIDs for custom groups. ... you created the workgroup file. ... permissions; or use Jeff Conrad's tool to document the existing permissions. ...
    (microsoft.public.access.security)
  • Re: Workgroup security files.
    ... If I have an employees DB and a press release DB on my ... workgroup file you are using, not the database file you are opening. ... The workgroup either has a password on the "Admin" user or it doesn't. ... and the prompts will go away. ...
    (microsoft.public.access.security)
  • Re: Question for Joan (or anyone with knowledge of security)
    ... You could always create a desktop shortcut to specify the workgroup file to ... Joan Wild ... >>> Should there be an LDB file in the folder where I saved the NEW ...
    (microsoft.public.access.security)
  • Re: Workgroup security files.
    ... >workgroup file you are using, ... an error message is displayed and it ... >and the prompts will go away. ... shortcut for your ...
    (microsoft.public.access.security)