Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access - SQL Server 2000 Linked Table Question

Status
Not open for further replies.

hoppergs

IS-IT--Management
Feb 24, 2003
39
0
0
GB
We have recently migrated some data from an Access database onto SQL Server. Part of this migration included us moving the largest tables into SQL Server and setting them up as "linked tables" from Access.

One strange happening is that one of those linked tables is much slower than the rest - and most of the others are significantly larger.

Any ideas why this should be happening? The table is indexed in a similar way to the others.

Thanks

Graham
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top