468,316 Members | 2,131 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

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

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
0 969

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by NickBlooruk | last post: by
2 posts views Thread by Robert McGregor | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.