save database UserID from linked ODBC to Access

130 Views Asked by At

I have an Access 2007 database with tables linked to Oracle through ODBC. I need to record the UserID of the person logging in to Oracle through the ODBC connection since it can be different from PC user. Is there any simple way how to do that? I tried a pass-through query (current_user) with no luck so far.

0

There are 0 best solutions below