Hi please could you tell me the fastest way to update an access database from and sql server.
If i run the query directly from access it only takes 25 secs to update 16,000 records.
However I fill a database with data, open a connection to the access data base and loop through each row, then close the connection at the end. But this takes 3mins and thats from when the connection opens. (Not including the fill).
The reason for filling a table is so I can use a progress bar like access does.