Using Access 2007 SP2.

I am using ODBC linked tables and passthrough queries (dsn-less) connected 
to an SQL Server 2008 R2 Express database.

When a different user, other than had previously opened it, opens the Access 
application, I relink all of the tables and passthrough queries using the 
new user's login and password.

However, when viewing the trace to SQL Server via Profiler, I see that 
Access is still passing the old user's login.

This happens whether I simply re-link the tables, or delete and recreate 
them.

Is there any way to force Access to use the new user's login? So far, all I 
have figured out is to force the app to close, after relinking, and have the 
user reopen it.

Along the same lines (though not so important), in my connection string, I 
supply the applicationname. However, when monitoring the trace, I see that 
sometimes Access uses my applicationname and sometimes it uses the name of 
the accdb file. It would be nice to be able to control this also.

Thanks for any assisstance.

-- 

AG
Email: npATadhdataDOTcom

if you were using Access Data Projects (one single connection to SQL), you wouldn't have to worry about any of this extra BS.