Not a valid account name or password.

[ccook]

Hi:

With Win 2K and Access 2000. Set up a user account to match exactly
how the user logs into the network. Gave the person all rights to
everything as a user (not a group member). Then, logged into the users
w/s as the user. Logged onto Access and left PW blank but get the Not
a valid account name or password error. Still can get into Access but
when you go into Tools, Security, the login box comes up again.

I assume therefore that Access uses integrated security (reads the
machine/network login ID). Also, if you give the user full rights to
the DB, do you need to grant them all rights to every form, query, etc?

Thanks in advance,

Carol