Security usernames?

[Chad]

I am working with Access 97, and there are users and
permissions set on the database, but when I open it up on
some computers, it says "You don't have the necessary
permissions to use the xxx.mdb object". On other
computers, (the ones that have the users allowed on them)
when I open it, it just goes right to the correct form.
Why does it not ask for a user when I open it on the valid
computers? How does access know what user is opening it
and what rights to give that user on the database? Thank
you very much in advance. If you can e-mail me your answer
that would be much easier for me. Thanks a lot..

(e-mail address removed)

 

[Joan Wild]

Users, passwords, Groups, and users' membership in groups is stored in a
workgroup file. Every session of Access uses a workgroup (even in unsecured
databases). The permissions that groups/users have on objects in a
database, are stored in the mdb file.

Users of the mdb must join the correct workgroup to gain access to a secured
database.

Each computer will have a workgroup file set as the default one to use. If
the default one is the correct secure workgroup, then they will get access
to the secure mdb. If it isn't, they will get the error message
"...necessary permissions...".

The easiest thing to do, is to use the workgroup administrator to join the
standard system.mdw as the default. For secure databases, use a desktop
shortcut that specifies the workgroup file to use for that session. The
target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"