Apologies for the delay, lost contact with Internet.
The code was linked using the ODBC tool on the MS Access 2010 'External Data' tab. I do not link the tables during code execution.
Thanks Mike, I have received the info. I will run a test and advise soonest.