Passing Application name in ConnectionString

[Don]

Hello, I have a custom Access application that runs on a SQL Server. I want
to be able to see which processes on the SQl Server are for this custom
application and not someone using Access to just link to this database. The
application column on the SQL Server process screen always show 'Microsoft
Office 2003', is there anyway to override this. I tried the following code
below but the
value stayed 'Microsoft Office 2003'

Thanks

SQLCONNECTSTRING = "ODBC" & _
";DRIVER={SQL SERVER}" & _
";SERVER=" & SQLConnectSERVER & _
";AppName=CustomApp" & _
";DATABASE=" & SQLConnectDatabase & _
";TRUSTED_CONNECTION=Yes;"

 

[Paul Shapiro]

On the Server Connection properties dialog in Access, on the All tab, the
first property is Application Name. When I edited it in an Access 2007 adp,
the application name I assigned is what appeared in SQL Server 2005's
profiler. But I don't see the name in either CurrentProject.connection or
CurrentProject.BaseConnectionString, so I don't know how Access is using
that setting in the connection string.

You could try http://www.connectionstrings.com/.