Re: when do you outgrow access?
- From: "Red_Star20" <RedStar20@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 08:29:03 -0700
i just got my new job for the summer and the upcoming year. We have been
using an access based system to take online applications for students who
want to enroll in our international programs going overseas every summer.
Apparently, they have been having some difficulties with the current system
such as not capturing some of the applications and crashing when multiple
users were trying to enter new data, etc... I did not myself see it work as
the programs are over now, but the director of IT suggested to swithiching to
Oracle, in fact the database is already done. we have probably 300 students
applying every year and we have reports generated for the program
coordinator. I find it hard to believe that Access could not handle the
load.... Do we really need Oracle?
"david epsom dot com dot au" wrote:
> I'm GUESSING that the date format in Paradox is different
> from that in Access, and Access is bringing the data into
> Access to do the date conversion, rather than asking Paradox
> to select the records. If so, you may be able to get an
> immediate speed up by querying using a native Paradox format
> rather than a Jet/VBA date. For example, in Access (using
> mdb tables), this is faster:
> select * from tbl where dat > 10305
> than this:
> select * from tbl where dat > #03/18/1928#
> because the numeric format is closer to the native format.
>
> (david)
>
>
> "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
> >>
> >>
> >
> >
>
>
>
.
- Follow-Ups:
- Re: when do you outgrow access?
- From: Larry Linson
- Re: when do you outgrow access?
- Prev by Date: RE: report that includes multi tables
- Next by Date: RE: Adding a seperate Switchboard menu
- Previous by thread: report that includes multi tables
- Next by thread: Re: when do you outgrow access?
- Index(es):
Relevant Pages
|
