Re: when do you outgrow access?

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?
    ... Sounds like your query may need some fine-tuning. ... <MS ACCESS MVP> ... > been added with a certain date...the date filed is indexed in Paradox (and ... >>> 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)
  • Re: when do you outgrow access?
    ... -- web access that is fully secure; ... > Just wondering....IT department bags on access and pushes to change. ...
    (microsoft.public.access.gettingstarted)
  • Re: PARADOX product life cycle
    ... While it is without question that Corel ... presented any adverse effects to existing Paradox applications or even those ... Some Paradox developers have chosen to jump ship early while others intend ... Paradox developing platform. ...
    (comp.databases.paradox)
  • Re: Are Macros Evil?
    ...  > Paradox didn't have, ... I was a PDOX/DOS end-user and was eager to see the Windows version. ... Macros by developers didn't help their reputation either. ... are related to Microsoft trying to make Access 2007 more XML ...
    (comp.databases.ms-access)
Loading