I'm using MsAccess 2007, and I have two large tables of data, say tbl01 and tbl02, which are added to each month, and I have to update tbl01 from tbl02, based on different sets of linking criteria. This can take a long time. Would it help, if I appended to a temporary table with linked records from both tables, and then update tbl01 from the temporary table? (Or even perhaps try the linking the two table that contain the new month's data?)
I'm clutching at straws maybe, but I'm wondering how to improve the whole process.
I'm clutching at straws maybe, but I'm wondering how to improve the whole process.