This SQL Server procedure runs by any windows-validated user from Microsoft Access:
gdbSQLServer.Execute "[dbo].[udpARAging] '" & CDate([Forms]![frmPickDate]![txtPickDate]) & "'", dbSQLPassThrough
but this SQL Server scalar-valued function needs permissions, why?
GenerateInfoCallSSN = gdbSQLServer.OpenRecordset("SELECT dbo.udfTempSSN() As TempSSN", dbOpenSnapshot, dbSQLPassThrough).Fields(0)
for both:
Public gdbSQLServer As DAO.Database
Set gdbSQLServer = DBEngine.Workspaces(0).OpenDatabase _
("", False, False, "DRIVER=SQL Server Native Client 10.0;SERVER=USER-HP\GCUSERHP;DataTypeCompatibility=80;DATABASE=GCDA TA;APP=Microsoft Windows Operating System;Trusted_Connection=Yes;MULTIPLEACTIVERESULT S=Yes;Pooling=True")