|
| "Albert D. Kallal" wrote:
> WIDELY stated. Sure, joins via linked tables is a problem..but then again,
> users of other development environments DO NOT have this option anyway!!
> This
> issue here is of POOR practices...NOT ms-access!
We use Access MDBs primarily for report writing with ODBC linked tables back
to SQL Server. With a little thought you can get the same performance from
linked tables as you would with an ADP. Joins between local and linked
tables are obviously out (unless you don't mind the entire contents of the
linked table coming across the network) but pretty much all other joins will
translate correctly. A bit of monitoring with SQL Profiler lets you quickly
check whether or not Access can translate your query to something that runs
server side, and once you get to know what it likes you can write very
complex queries that always run server side.
Kind Regards,
Paul
|
|