I do many distributed query from Ms Access & Ms SQL 2000,
I already try link server, but performance is slow,
My question are :
1. If I used DTS for perform distributed query, is
performace better than link server ?
2. Does Ms Access support DTS object like vb ?

Thanks

DTS has an object model and as long as you register the dlls you can use it
in Access, VB, c# etc etc.
DTS is very very quick when going between Access and SQL Server in general.
Obviously a caveats apply like the link isn't a 56K dial up over the
Atlantic.

As for linked servers have a look in profiler at what SQL Server is doing.
Chances are if you have specified a 4 part naming then it is retrieving each
row 1 * 1. Try using OPENROWSET this may help.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Kresna Rudy Kurniawan" <kresnark (AT) yahoo (DOT) com> wrote