MS access login issue

Hi

We use MS Access 2000 application to login to and do inventory management,
This access database uses linked tables via ODBC to SQL server 7 database to
transact, and also logins to application validated against SQL database user

all of a sudden, the user who used to login to access, can no longer login
from his workstation, error message saying this user "proccess did not
complete, due to duplicate record cration.... in a table"

Same user can login from different computer no problem.
Has anyone encountered such issue with MS access?

It is as if, his PC somehow locked his user name password and preventing him
login from that PC
Removing office product (with MS access) and re-install did not work, it has
to be, something to do with ODBC drivers or MDAC components where this user
ID is being locked somehow


MC

What is the login process? What does the MS Access application do when a user
logs on, does it update any tables?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"MC" wrote:

Hi

We use MS Access 2000 application to login to and do inventory management,
This access database uses linked tables via ODBC to SQL server 7 database to
transact, and also logins to application validated against SQL database user

all of a sudden, the user who used to login to access, can no longer login
from his workstation, error message saying this user "proccess did not
complete, due to duplicate record cration.... in a table"

Same user can login from different computer no problem.
Has anyone encountered such issue with MS access?

It is as if, his PC somehow locked his user name password and preventing him
login from that PC
Removing office product (with MS access) and re-install did not work, it has
to be, something to do with ODBC drivers or MDAC components where this user
ID is being locked somehow


MC

.

the person has SQL server user name and password to enter in Access form,
then access go in to SQL server verifies user name and password, if
successfull, SQL database logs login date and time information.

It is strange enough that the same user name and password works on different
computer
I use my login ID and password to this program on his PC, I can login no
problem

MC

"Dorian" wrote in message
...
What is the login process? What does the MS Access application do when a
user
logs on, does it update any tables?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and
they
eat for a lifetime".


"MC" wrote:

Hi

We use MS Access 2000 application to login to and do inventory
management,
This access database uses linked tables via ODBC to SQL server 7 database
to
transact, and also logins to application validated against SQL database
user

all of a sudden, the user who used to login to access, can no longer
login
from his workstation, error message saying this user "proccess did not
complete, due to duplicate record cration.... in a table"

Same user can login from different computer no problem.
Has anyone encountered such issue with MS access?

It is as if, his PC somehow locked his user name password and preventing
him
login from that PC
Removing office product (with MS access) and re-install did not work, it
has
to be, something to do with ODBC drivers or MDAC components where this
user
ID is being locked somehow


MC

.

It sounded to me like the Access db was recording the login and logouts and
maybe could not log someone in because they did not log out before. If that
is not the problem, I don't know what it could be. You first have to isolate
whether the problem is coming from SQL Server or from Access.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"MC" wrote:

Hi

We use MS Access 2000 application to login to and do inventory management,
This access database uses linked tables via ODBC to SQL server 7 database to
transact, and also logins to application validated against SQL database user

all of a sudden, the user who used to login to access, can no longer login
from his workstation, error message saying this user "proccess did not
complete, due to duplicate record cration.... in a table"

Same user can login from different computer no problem.
Has anyone encountered such issue with MS access?

It is as if, his PC somehow locked his user name password and preventing him
login from that PC
Removing office product (with MS access) and re-install did not work, it has
to be, something to do with ODBC drivers or MDAC components where this user
ID is being locked somehow


MC

.