Workgroup

[legacy]

I created a workgroup for different users, but when I opened the database in
someone else computer which is connected to a network it does not promt them
to enter a username or password.

 

[Rick Brandt]

I created a workgroup for different users, but when I opened the
database in someone else computer which is connected to a network it
does not promt them to enter a username or password.

Naturally, they are not joined to that workgroup. If they were able to open
the file then you did not apply security properly.

 

[legacy]

So how do I setup the workgroup so everybody in the network is prompted to
enter a username and a password. I realized that anybody that opens the
database in another comuter it recognizes the defualt system.mdw when a
database is open for the first time. I would really like to incorporate the
workgroup into the network. Any help will be appreciated.

Thanks

 

[Rick Brandt]

So how do I setup the workgroup so everybody in the network is
prompted to enter a username and a password. I realized that anybody
that opens the database in another comuter it recognizes the defualt
system.mdw when a database is open for the first time. I would
really like to incorporate the workgroup into the network. Any help
will be appreciated.

The workgroup is about the session, not the file. You can only get everyone
prompted by having everyone use a workgroup that forces a prompt. The MDB file
does not control that. The workgroup (MDW) file being used does.

So step 1 is to get to a point where users who do not use your workgroup (and
who are not prompted) cannot open the file.

Step 2 is to then create a shortcut that opens Access while specifying your
workgroup and your file as command line arguments. Both of those files need to
be placed somewhere on your network where all users can access them.

Then you give a copy of that shortcut to all users and instruct them that to run
your file they will have to use that shortcut.