Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Callaway7
Starting Member
3 Posts |
 Posted - 2005-02-07 : 21:10:50
|
| If this belongs in the Administration forum, please move it there.I've created a File DSN connection which enables me to Link tables in Access to another box running SQL Server 2000. When I link a small table with only 5 records in it, the SQL hard drive spins like mad...I mean like MAD. When I first try to link the tables, it goes nuts for about 30 seconds. After linking the table, it still goes nuts for about 3-4 seconds and then finally displays the data. If I click around in any of the 5 records, the SQL drives will chirp for a split second.Anyone else run into this? Do you recommend not linking tables in Access? Is there a performance hit or is this normal?-P4 1.3-512mb RDRAM-40gb ATA 100 |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-02-08 : 04:07:53
|
| check other ODBC settings (on its control panel)maybe e.g. ODBC trace logging is ON. |
 |
|
|
|
|
|
Linked Tables - Huge drain on SQL Drives?