Mixed credentials: AD and SQL Server?

[Svendmidtgaard]

I am working on a adp-project with all data located on a MS SQL-server. I want my users to use their AD-account for login. In one of the forms i join data from a table located in another database (on the same server) "Forsyning":

SELECT bsys.BrondID, bsys.Adresse1, GIS.ID, GIS.DZONE
FROM tblBrond bsys
LEFT OUTER JOIN Forsyning.VARME.BROENDFC GIS
ON bsys.BrondID = GIS.ID COLLATE Danish_Norwegian_CI_AI

My problem is that the database "Forsyning" uses SQL-security, not AD-security, and this cannot be changed because it is data from Esri ArcGIS. I want all users to use the same specific "read"-user to view data from GIS.

My question is: Is it possiple to tell (some of?) the SQL-statement to use specific credentials, that are different from the users credentials? Or is it possiple to tell the Access-form to use specific credentials different from the users credentials?

Thanks in advance for any usefull answer.

Svend

 

[Rx_]

Sorry for a very late response.
The short answer is yes.
When creating a connection object, this can (must) be determined.
When for example creating a linked table with code, one link can use one security while the other uses a different one.

BTW, Esri ArcGIS odbc drivers seems to be an issue for me too.
It is "picky".
In the old WOSA (Windows Operating System Arch) certification days, there was an ODBC Levels (compatibility) questions.
It is too bad that many modern systems don't adhere to basic quality anymore.