Communication Link Failure [#0] Access7.0 SQL 6.5

Communication Link Failure [#0] Access7.0 SQL 6.5

Post by Alex Chan » Fri, 17 Jan 1997 04:00:00



Hi all,

I use MS Access 7.0 query "append to" function(on Window95) to transfer
data from one attached table (AS/400) to another (SQL Server 6.5). If
it is a big file, sometimes I got "Communication link failure"
message when the data are inserted into SQL server. Anyone has idea what
might cause this problem? Timeout or locks on SQL server? Thanks.

Alex Chang
Formosa Plastics Corporation