Hi, I have a linked server in sql 7 that connects to a ms access 2000 database. It has been working for a while, however lately, after we imported a large amount of new data, the database fails to query a certain (large number of records) table. I can query and get responses for every other table except the largest table. select top 5 * from linkeddatabase...table I get this error message. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()). [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation. Connection Broken I called a collegue and he suggested removing the primary key index (which was multi field), creating an autonumber field and making it the primary key, and then building a unique index on the two fields that were formerly the primary key to insure the data stayed unique. This index restructing fixed the problem. (Thanks Joe!) Justin