I'm trying to insert records into an SQL Server table that is linked in MS Access. Nothing happens, no error and no record inserted. Any idea what I'm doing wrong?
Dim db As Database
Set db = CurrentDb
db.Execute "INSERT INTO [ODBC;DRIVER=SQL Server;SERVER=10.0.0.5;DATABASE=dev_Test].LOCATIONS ( Location,Loc_Name ) SELECT Location,Loc_Name FROM LOCATIONS Where Location = 'TEST'"