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.