Recent content by Bellage

Well thanks to you all for your support. It appears my execution efficiency was primarily down to the lack of indexes. It is now executing in a matter of seconds! :cool: I have to say that I'm a little annoyed with myself as creating indexes is normally the first port of call for poor query...

Thank you all for your responses they have been very helpful and I have learned a few things! My understanding so far is: linked tables even with an ODBC connection don't operate as a passthrough Without a passthrough queries will use the MS Access Database Engine which can be slower and...

Hello All! I'm executing the below code as part of a larger procedure and it's taking ~3-4 mins to complete which feels lengthy. I'm wondering if there is a more efficient approach that I could use or if this time would be usual for itterating through ~100 update statements? CurrentDb = linked...