Posted by Steve Jorgensen on 10/30/05 13:28

On Sun, 30 Oct 2005 01:03:04 GMT, "Neil" <nospam@nospam.net> wrote:

>Yes, it can be done on the Access side, but, as noted, things are slowed
>down. When I had a main SQL table (50,000 records) joined to a local Access
>table (also 50,000 records, with an index and a boolean field), the form
>took about 13 seconds to open (with the join being, of course, in the front
>end).

You really need to read up on the performance issues of using Access as a
front-end to SQL Server. There are a few basic rules to know, (such as making
sure join fields are indexed, and every table has a primary key) but if you
follow them all, you should not have the performance issues you are
describing.

I routinely just build plain ol' Access queries that use criteria and join
muliple linked tables together. JET is smart enough to build prepared
statements and process the joins at the server side, so performance is pretty
good.

[Back to original message]