Not getting login prompt

[jodyblau]

I applogize for posting this a second time (I posted in the
access-multiuser group as well), but this group seems to respond more
rapidly, and I have been trying to figure this out for what seems like
forever.

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

[Anthony England]

"jodyblau" <jo******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

I applogize for posting this a second time (I posted in the
access-multiuser group as well), but this group seems to respond more
rapidly, and I have been trying to figure this out for what seems like
forever.

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

The piece of the puzzle you are missing is the workgroup (mdw) file. I
imagine what you have done is change the password for the admin account in
your local workgroup file. In a typical Access XP installation this file
would be stored in:
C:\Documents and Settings\Anthony\Application
Data\Microsoft\Access\System.mdw
Given that the windows user is named Anthony.

If your mdb is accessed from another computer, Access will typically try to
log in using its own version of the Admin account which is almost identical
except it will not have a password set. So it tries to log in with
username="Admin" and password="" and if this is successful the user never
sees a prompt and you get logged straight in.

But isn't this a security flaw? No, it simply means you should remove all
permissions from the Admin account which you do by removing Admin from the
group Admins. There is a bit of learning to do to set up user-level
security, but certainly I would recommend that you always create a new mdw
file for each secured database you create and that you open your application
with a special shortcut which specifies the use of this file.