Hi Sharon,

Could you please provide me with more information, such as how are you connecting, i.e. are you using file DSN's or system DSN's for your ODBC connections, and the...

Thanks very much, appreciate the quick and helpful response.

Would you have that automated process code to share, as I have similar issues with database table updates getting locked when Access queries run.

Many thanks