I have also run into the same problem. Front end Access DB with back end SQL DB, and from time to time I get the 'runtime error 3146 - ODBC...