Re: speed up link tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Tue, 30 Sep 2008 17:17:01 -0700, tracktraining
<tracktraining@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

This is my SQL(DocInfo):

SELECT [Part Master].PRTNUM_01 AS DocID, [Part Master].REVLEV_01 AS Revision
FROM [Part Master] LEFT JOIN [Mfg Part Master] ON [Part Master].PRTNUM_01 =
[Mfg Part Master].PRTNUM_49
ORDER BY [Part Master].PRTNUM_01;

I am using Access 2003.

The linked tables are in pervasive database. So [Part Master] and [Mfg Part
Master] are linked tables.

Running this particular query is not causing any speed problem. Running
other queries or opening up any form that uses this query takes up a lot of
time.

Let me know if you need any other information.

If possible, put some sort of criteria on the query to limit the number of
records retrieved. There's not enough information shown to suggest how, but
perhaps if there is a PRTNUM_01 field on your form you could use it as a
criterion.
--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Query to search entire record, not one field?
    ... > in criteria for all fields in my Query. ... > There is not information for the "State" field in my master table for this ... >> Rick B ...
    (microsoft.public.access.queries)
  • Re: Query to search entire record, not one field?
    ... I think we (okay YOU) have solved the problem. ... >> in criteria for all fields in my Query. ... >> If I enter a state in my Master Record and then leave State blank (or ...
    (microsoft.public.access.queries)
  • Re: Query to search entire record, not one field?
    ... I have a form with unbound fields now, ... >> in criteria for all fields in my Query. ... >> If I enter a state in my Master Record and then leave State blank (or ...
    (microsoft.public.access.queries)
  • RE: speed up link tables
    ... The linked tables are in pervasive database. ... So [Part Master] and [Mfg Part ... Running this particular query is not causing any speed problem. ...
    (microsoft.public.access.formscoding)
  • Re: query criteria
    ... I tried your idea but it returns all records on the left outer join (master) ... table side when a criteria is placed in the earliest received date field ... Create a query using the table on the outer side of the join ...
    (microsoft.public.access.queries)