linked and imported tables in MS Access from MS SQL Server 2000

linked and imported tables in MS Access from MS SQL Server 2000

Post by Kamy » Fri, 22 Apr 2005 00:29:41

Hello all!

I have such question to all of you.
I have some tables linked from MS SQL Server 2000. Is time of processing
based on these linked tables from MS SQL Server 2000, faster or slower than
the time of processing the same query based on tables, which are not linked
imported to MS Access?

Can you answer this question?

Thank you in advance for posts
Marcin from Poland.

1. Problem by design - MS-SQL Server 2000 and MS-Access 2000 project.

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


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

select top 5 * from linkeddatabase...table

I get this error message.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
[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!)


3. CPU usage changed after upgrading to MS SQL Server 2000 from MS SQL Server 6.5

4. best pratices for transferring MS SQL Server 7 database to MS SQL Server 2000

5. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000

6. Interface between the MS Sql Server 2000 and the MS Exchange Server 2000

7. I cannot upgrade MS SQL Server 6.5 to MS SQL Server 2000

8. update several MS Access tables into SQL server 2000 tables

9. MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem.

10. Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?

11. how to access MS Access table from SQL Server 2000?

12. MS Access 2000 and MS SQL 2000

13. Automated MS Access 2000 tables/queries to MS Word 2000 Template

14. executing a stored procedure on MS SQL Server 2000 within MS Excel 2000

15. Add MS SQL 7.0 server in MS SQL 2000 SEM