Home / monamour dating / Updating tables in access 2016

Updating tables in access 2016

I suspect that you are correct in that it will still only take a few seconds to update all of the currencies so maybe it's not a big deal...Bloating may not be much if you clear and write to the same table - or use an external file.Hello experts, I need to update the currency exchange rates in an Access (2010) tab many times a throughout the day.

Not a lot of bloat in the grand scheme of things, especially when the database is going to increase in size anyway due to normal data entry so probably nothing to worry about. You may find that rephrasing your criteria to locate a specific record is faster, especially when working with large recordsets.

The down side is with 120 currencies to update function would run 120 times for each overall currency update process.

Not very efficient but maybe it doesn't matter in the grand scheme of things.

I think a faster recordset method would do something like this: * Instantiate a recordset object against the base table (db Open Table) without any row-limiting criteria * Start a transaction (Begin Trans) * For Each item in your update collection/dictionary, invoke a recordset .

FIND method for the key to the row to be updated, then use rs. Update to change the row * After all your updates, invoke the Commit method to end the transaction.

19 comments

  1. In Access 2003, from the menu choose Tools, Database Utilities, Linked Table Manager. In Access 2007 from the ribbon choose Database Tools, Linked Table Manager. In Access 2010 from the ribbon choose External Data, Linked Table Manager.

  2. Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. You currently have 0 posts.

Leave a Reply

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

*