By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

linked server from sql 7 to ms access 2000 ... some tables not available - solved

P: n/a
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

Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.