Getting error 3155 on a SQL linked table upload 1

[ljvb7]

The code in question unlinks then relinks a SQL table thru an ODBC connection, then initializes the table, then transfers comma delimited text.
I am getting the error 3155 regularly lately, and the table values are valid, and the permissions are ok, so it seems that I am losing the ODBC connection. To resolve the error, all I've been doing is restarting and it moves along ok.
The file in question that I'm importing is pretty big. I once reset the timeouts in the Access table/query to allow more time to process, but I am getting the error more frequently. Anyone encountered this before?

 

[DougP]

Why don't you just leave the ODBC connection hooked.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[ljvb7]

Dougp, you know I inherited this part of the code, the writer linked & unlinked each table before updating, he's long gone, but I assume it was to maintain or ensure the jet connection. In further development, I could experiment with rem'ing out that code, but this is daily production, and I need to resolve the current code issue now.