User & Group Accounts & Security

  • Thread starter Thread starter Duncan Edment
  • Start date Start date
D

Duncan Edment

I've created a database for 8 users. Each user should only be able to view
/ edit their own details, so I added User & Group Account security to the
database. The database, BTW, is run off a network server, but is not split
into back/front end, running Windows 2000 and Access 2000.

Each user has a User name that is the same as their LAN ID, and each user
has specified a password to access the database. This information is, I
believe, held in the file system.mdw. What I've done is this:

1. On my own work PC, I've setup the accounts and created the
system.mdw file, which is located in my "My Documents\Windows"
folder;
2. I've then copied this file into a temporary directory on the
server;
3. I've asked each user to copy the file from the temporary
directory, into their own "My Documents\Windows" folder,
overwriting the file that is there;
4. They then open the database, but it does not ask them for a User
ID / Password. They are all logged in as me, the database Admin
user;

What am I doing wrong here?

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.
 
Scott,

I've checked the database, and the "Admin" user--who is
only a member of the "Users" group--has a password set.

My own ID, is a member of both "Users" and "Admins"--the
only ID within the database that is like this--and I have
a password set.

However, I've just tried it tonight again--I know,
Saturday night GMT, and I'm in work--and the database
still refuses to prompt for a password.

Any suggestions?

Thanks & Rgds

Duncan
 
How are you opening the database? Are you using the correct workgroup file
(i.e. the one where you are adding/editing the Users)? Generally, you do
this via a shortcup, where the Target is set like this:

"Path To MSAccess.exe" "Path to your database" /wrkgrp "Path to your
workgroup file"

Access ALWAYS opens with a workgroup file; if you don't specify which file
to use, then Access defaults to the system.mdw file stored at a particular
location (where depends on your OS and your version of Access - on my XP
Pro/Access XP machine, this is at C:\Documents and
Settings\Scott\Application Data\Microsoft\Access, where Scott is the current
UserProfile). The file your users are copying to their machine is NOT the
one being used to open their db UNLESS you use the syntax as described
above.
 
The easiest way to use the correct workgroup file is to mount a single
copy on the server. Then give each of your users a shortcut to launch
Access under the correct workgroup (watch for wordwrap). use the
following syntax in the shortcut target

"fullPathToAccess.exe" "fullPathToDatabase" /wrkgrp
"fullPathToWorkgroupFile"

See the website in my signature for additional information.
 
Back
Top