Multiple Users with Linked Oracle DB

[RichF01]

Hi All,

I have developed an Access 2000 system which can be used by many different users, with a series of links to tables in an ODBC back end (which i have no control over). This is on a multi-user network.

When I use the system, I am prompted for my password access to the ODBC back end. When another user tries from the Access DB, they are also prompted for my password, based on my userID.

How do I set-up (probably in code) so that when the ODBC is linked to, the appropriate userID is prompted for?

Cheers

Rich

 

[easyit]

Hi,

I'm no expert on this matter, but it seems that all your users are using the same ODBC connection rather then a odbc connection to the same DB.
Did you set up a DSN for this connection? If not where are the properties of the connection set 9code, query, table, etc)


EasyIT