I have the Access 2002 Developer's Handbook, and I am trying to learn
from the example provided in Chapter 2, but I am running into the
following problem.

I set an admin password and a username and password on the backend,
then the following things happen:

1.  If I open up the frontend on the same computer as the backend, I am
prompted for the username and password.  Which is what I expect and
want.

2.  If I use a different computer on the network to open the frontend
(using the frontend copy on the serving computer, rather than a copy of
the frontend placed on the second computer), then I am not prompted for
a username or password (even though this is the exact same file which
prompts for password when I open it directly on the serving computer.)
When I check the list of users, it shows that I am logged on as an
Admin from the second computer, even though it didn't prompt me for the
Admin password.

3.  If I put a seperate copy of the frontend on the second computer, I
am not prompted for a password, and I don't show up as a user in the
frontends on the serving computer and the second computer don't
recognize that another computer is logged on.

My Questions:
1.  Can someone please explain why the second computer is not being
prompted for a username and password?

2.  I thought that once I split the database into frontend and backend,
I could put a seperate copy of the frontend on each computer on the
network, rather than everyone using the same frontend off of the
server.  If this is true, can someone explain how someone logged on as
admin using their copy of the frontend can view a list of all the other
users logged on to the backend using their own seperate copies of the
front end?

I would be happy to email anyone the Developer's Handbook chapter 2
example database that I am using, if that would be helpful.  Or I would
be happy to receive a different example by email.

Thanks,

Jody Blau