Getting Name in Connection String

D

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 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;"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top