sql server 2008
I'm having issues with a locked sql server table, i think from this small routine. ?
So , i need to try and
I need to call a function to get a value from a sql server procedure.(I currently do not have a function/procedure)
I need to assign that value from sql server to a variable.
Current Access vba code Linked to a sql server table. I would like Sql server to tell me the answer and not VBA.
StrSqlC = "SELECT Max(dbo_t_nsc_trackcode_assigned_DataEntry.NSC_Id) AS MaxOfNSC_Id " & _
"FROM dbo_t_nsc_trackcode_assigned_DataEntry" & _
" WHERE (((dbo_t_nsc_trackcode_assigned_DataEntry.ID_Racfid)= '" & str & "' ));"
Set r = CurrentDb.OpenRecordset(StrSqlC, dbOpenDynaset, dbSeeChanges)
tp = r.RecordCount
MaxId_csp = r.Fields(0)
Set r = Nothing