I am hoping to find some help with this. Does the security on the ODBC setup on the PC take precedence over the VBA code coming to the server via the ODBC?
We have a number of spreadsheets with VBA that connect to SQL over ODBC. In this particular case all admin users can run this button but one of the public users needs to run this and gets the "Run Time Error '3156" ODBC - delete on a linked table ???? failed. VBA code:
set dbname = OpenDatabase("name", dbDriverNoPrompt, False "odbc;database= name; driver = sql server; server; server = servername; uid = adminname
database.Execute "DELETE FROM TABLE", dbSeeChanges
Thanks