Avatar of taz8020
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

What is the fastest way to update a access database

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.
Microsoft DevelopmentMicrosoft SQL ServerMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon