M
MC
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
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