Dear Experts,
I have to create an application in MS Access with MS SQL backend where users can log in with their actual windows credentials, in order to trace each user's activity on the server. Additionally, at login, the program have to provide the possibility to log in with different credentials than the actual windows user's.
Is it possible to create a connection to the SQL server with windows authentication, but not with the current user's credentials? Or is there other way than the connection with windows authentication, to satisfy the requirement?
Thank very much in advance for any piece of tips!
VoiD
I have to create an application in MS Access with MS SQL backend where users can log in with their actual windows credentials, in order to trace each user's activity on the server. Additionally, at login, the program have to provide the possibility to log in with different credentials than the actual windows user's.
Is it possible to create a connection to the SQL server with windows authentication, but not with the current user's credentials? Or is there other way than the connection with windows authentication, to satisfy the requirement?
Thank very much in advance for any piece of tips!
VoiD
