(Solved) – Update records in another database with VBA


I’ve 2 databases, 1 on the C-drive and the other on a networkdrive.
Both databases have the same tables.
Now I want to update the tables of the databaase on the networkdrive with the data in the tables which are stored in the database on the C-drive.

To add data, I’ve already a code and now I want to update the records with runSQL “update”.
But I’ve trouble with the criteria ordernr = ordernr in the code.

With Access.DoCmd
.RunSQL "Insert INTO orders IN 'F:BraakmanHOB serverIBS-data.mdb' SELECT * FROM orders"
End With
End Sub 

thanks in advance,



Leave a Reply

Your email address will not be published. Required fields are marked *