Public User over ODBC with Excel VBA code not running Execute command on SQL table - SQL 2005

• susan.swaffield

  SSC Rookie

  Points: 32

  More actions

  June 18, 2015 at 4:59 pm

  #147339

  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