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