I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table.
I have tried multiple things and the final state it is in is shown below:
DoCmd.RunSQL ("UPDATE TBLRemote IN '" & path & "', TBLLocal SET " & _ "(TBLRemote.[UpdateField] = [TBLLocal]![UpdateField]+1 WHERE . . .) ;")
path is the connection to the remote database, however this is not correct syntax. I am looking for advise on the correct syntax.
I would like to figure out how this fairly old method was carried out... Tips would be very much appreciated.