Access 2000 -> sql server 2000
I'm finding access adp is slow querying data but the same query in enterprise manager or query analyzer is fast.
*The majority of slowness comes when the combo box wizard is getting the sample values to show you after you choose the table and columns.
client net tools is set to use tcp/ip on :1433
What could be the issue ?
I'm finding access adp is slow querying data but the same query in enterprise manager or query analyzer is fast.
*The majority of slowness comes when the combo box wizard is getting the sample values to show you after you choose the table and columns.
client net tools is set to use tcp/ip on :1433
What could be the issue ?