Posted by Russ Rose on 03/06/07 05:35

"SQL Learner" <excelmodeling@gmail.com> wrote in message
news:1173140746.926758.48820@h3g2000cwc.googlegroups.com...
> Erland and Greg,
>
> Perl is not my thing. Beside, in this project there are actually two
> tables that need to be links. The thing is that since many records
> can only be linked using partial criterial (ex: "123" to match "abc123
> xyz"), I still need to do this in a database.
>
> Russ,
>
> If I do this through ODBC by using Access as the front end (query
> only) and SQL Server as the end back, how much slow down would this be
> compares to run the query on SQL Server without using the ODBC linked
> to Access?

Not much if Access is run on the server with the data. If you are dragging 8
million rows across a network you are in for a long, long, long night.

>
> Thank you all.
>
> - Grasshopper -
>

• Next in forum: Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE.
• Prev in forum: Delete and update
• Thread view: Re: Access and SQL Server Speed Comparison

[Reply to this message]