Setting Application Name

[BobS]

I have an Access Application that updates a table in SQL Server. I would
like to set the Application Name in Access, so that it shows up in SQL
Server, either in the APP_NAME() function or in SQL Profiler. The name can
be included in a connection string (Application Name = xxxxx), but I am
connecting with a DSN. Is there any way in access to add a connection string
parameter to the DSN?

 

[Arvin Meyer [MVP]]

A number of ways. Have a look at Carl Prothman's website on connection
strings:

http://www.carlprothman.net/Default.aspx?tabid=81