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,