<div>
The fastest way is through the query directly or export the data from sql server to CSV then import it as a local table to ms access, then run your update query. &nbsp;That might be even faster. &nbsp;Then if you really want you can implement your custom progress bar when you loop through each record in the local table to execute the update.
</div>


<div>
Even if i query directly in my app it takes 59 secs I can not get close to the time access takes. And they give a progress bar. I have not tried exporting it to a CSV first but thought this would add time.<br />
Access must do it through a loop for the progess bar.
</div>


<div>
How are you opening the connection and such? Are you using Stored Procedures to somehow do this?
</div>


<div>
<div class="content wysiwyg-content">
Hi please could you tell me the fastest way to update an access database from and sql server.<br />
If i run the query directly from access it only takes 25 secs to update 16,000 records.<br />
<br />
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). <br />
<br />
The reason for filling a table is so I can use a progress bar like access does.
</div>
</div>


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.

What is the fastest way to update a access database

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.