I have an Access 2000 DB that needs to be accessed by multiple users. I connect to Oracle tables with an ODBC. The users however do not have unique user names. When one user logs in with the user name the previous user now lost the link the Oracle tables. So everytime a user logs into the DB they need to re-link the tables.
Is there something in the way I am setting up the ODBC drivers that is causeing this or is it that two users can't log into into the same DB with the same username?