Re: when do you outgrow access?

Sounds like your query may need some fine-tuning.
--

Ken Snell
<MS ACCESS MVP>


"HarvestWind" <harvestwind@xxxxxxxxxxx> wrote in message
news:toudnTPD4cWdewXfRVn-iw@xxxxxxxxxxxxxx
> Ken...
> Noted your statement "millions upon millions of records"...
>
> I am using Access 2000 and linked to a Paradox table with just over
> 500,000
> records. I use Access to process the table to get all records that have
> been added with a certain date...the date filed is indexed in Paradox (and
> in Access when linked)...It is not a compliated query...but it takes
> almost
> three hours to run...with a 2.8 gig processor... Maybe I'm doing
> something
> wrong with the search...but I can't imagine trying to do the same with
> "millions upon millions of records"... I'd have to start it on Friday
> before
> leaving work and hope to have my data by the next Thursday!
>
> JP
>
>
> "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
> news:euviAgyYFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
>> When you need
>> -- completely "lockdown" security on the data;
>> -- 50 or so users concurrently;
>> -- millions upon millions of records;
>> -- money is available to pay for much more expensive software and
>> developers
>> -- web access that is fully secure;
>>
>> and a few other things potentially. Tell your IT department that it
>> should
>> enjoy its great benefits for low costs.
>>
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Donna" <Donna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:D2A064D0-B609-4F1E-9316-2FCF43B2AAD6@xxxxxxxxxxxxxxxx
>> > Just wondering....IT department bags on access and pushes to change.
>> >
>> > thanks,
>> > Donna
>>
>>
>
>


.

Relevant Pages

  • Re: when do you outgrow access?
    ... I am using Access 2000 and linked to a Paradox table with just over 500,000 ... >> Just wondering....IT department bags on access and pushes to change. ...
    (microsoft.public.access.gettingstarted)
  • Re: when do you outgrow access?
    ... I'm GUESSING that the date format in Paradox is different ... Access to do the date conversion, rather than asking Paradox ... immediate speed up by querying using a native Paradox format ... >>> Just wondering....IT department bags on access and pushes to change. ...
    (microsoft.public.access.gettingstarted)