Security and login to an Access database.

[Avon]

A database was created in Access with no security. There are forms, queries, reports,
macros, etc.
Knowing a thimble full about Access I sat with a user to create the security on
this database. We have 6 people who will need access to various parts of this database
and assigned the rights according to who will be doing what.
This database is on a network in a folder that all have rights to.
Anyway, the security only works on the Owners machine, she gets a login screen
and is accorded the rights we assigned. But, no one else can use this database.
We copied the system.mdw to the network folder. Obviously we shouldn't have
messed with this before we knew what we were doing. Now I would like this database
available to all six people and don't know what to do.

[Milton Skopinski]

What operating systems are you using? If you are using NT 4.0 I think I can help.

[brandon]

did you make sure to join the users to the system.mdw file? simply copying it to
the network is not enough. access uses a default system.mdw file until you use
the wrkgadmn.exe file to join your created system file. and if you only want to
use that system.mdw file for your specific database, then the best thing to do is
create a shortcut that points to that database using your network system.mdw file.

Avon wrote:

.

[Tole]

Avon,

Read what I wrote for Hugh posted below yours under the title User and Access2000.
That should help you out alot.

Regards

Tole

.

[Tole]

Dont use the default system.mdw. Create your own and then add every workstation
to that one. Make sure you also create an account for every user you have. I
wrote a reply to someone else about the same thing so I copied and pasted it
below.

What you can do is to first create a workgroup
information file(WIf). In access 2000 it is stored in \Program files\Microsoft
office\office\1033\wrkgadm.exe.
Providing office was loaded in the default directory. If it is not there, then do
a search on wrkgadm.exe. Select Create and proceed to create the new WIF. Now of
course you know you will need to store the database and the WIF(*.mdw) in a foler
on a network drive accessible to everyone that will use your Database, so do a
browse and save the WIF in the location you want it. (If you need more help on
WIF, type Workgroup information file in the help search box by clicking on the ?
on the toolbar) Now after you create the WIF, you go to Access and go to
Tools,Security and User and Group Accounts. (Note:You will have to create users
and group accounts if you want to be specific on who can access what. The default
groups are Users and Admins) You create new users by clicking new and add them
to what ever group(ie admins, users or other groups you create). Make a note of
the path you create the WIF in because you will need to add every workstation
that will use your database to this WIF so they will be prompted to log in.
Follow the procedure above to Join the Wif,when you run the Wrkgadm.exe on the
other workstations you select JOIN instead of Create as you did above, and then
broswe to the path you saved the WIF(*.mdw) in. It is imperative that you add
every workstation in your dept or other areas to the WIF or they will not be
prompted to log in as part of your group. Note: Be sure to create the *.mdw
before you create any user or group accounts. (The initial password is blank so
you just hit ok when prompted, but be sure to enter a user name of a user you
created though if it doesnt come up automatically). ( Note: Only the user can
change his or her password which is done on the Change logon Password Tab under
User and Group accounts, but only a member of the Admins group can Clear the
Password if the user forgets it. Clear Password option is located where you
create the user, you just chose the user in the drop down list and then hit clear
password.) You also will need to specify permissions for the users for all objects
(ie, Table, forms, queries,etc), by going to Tools, Security, User and Group
Permissions. It is best to add the permissions to the group(user, admins etc)and
not invidiual users because then all you have to do is add the user to that group
and they will inherit the permissions for that group. So as new users are added,
you dont have to do each person indiviually. So in your case if you have a
smaller group individually is good, or you can create several groups with several
different permission assigned and then add whichever users you want to the
different groups. Now as a new person is added you just added them to the group
with the permissions to the objects you want them to have access to. If for some
reason they can still access tables or other forms etc. Then check to see if it
automatically gave that group admin permissions and just uncheck what you dont
want them to have for example (read, modify design, update data, administer,
delete data, etc.

I hope this helps you out some

regards

Tole

.

[Tom Tavernier]

It may sound silly, but did the 5 other users join the system.mdw file on the network ?
They can do so via C:\program files\microsoft office\ms acces workgroup adminstrator.exe
Hope it helps,

Tom

Avon wrote:

--
Tom Tavernier +32-9-2448992
mailto:tom.ta...@teleatlas.com
Tele Atlas - The reference in digital mapping
http://www.teleatlas.com