SQL Server vs MS Access (1 Viewer)

[davebhoy]

Hi there

Can anyone tell me why a make table query runs nearly 4 times quicker in MS Access than the exact same query in Enterprise Manager? The query makes a table containing about 16000 records.

Thanks in advance.

Davebhoy

 

[The_Doc_Man]

Please don't double-post the same question. We consider it a really nasty habit.