We're in the process of migrating to SQL 7 from Access 2000.
Our largest table has about 990,000 records and although it does crash, it
isn't a daily thing.
BTW-We're accessing the db constantly; with several thousand customers
hitting it from the web side daily, and 40+ backend connections to it.
> -----Original Message-----
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 10:48 AM
> To: CF-Talk
> Subject: RE: Access question
>
>
> We all must remember Access is mainly
> a desktop database. It was never designed
> as a database backend for web data or to
> withstand simultaneous hits.
>
> I used Access as well for the database
> backend but had so many end user request to
> the DB that I had to move up to a more
> robust database backend such as SQL 7.0.
>
> Now things are just fine.
>
> If you do not make many calls to the DB then
> Access is fine. But all in all, your decision
> should be based on the number of hits, the
> type of data help within the database.
>
> Access can hold a vast amount of data. At one
> time, I had over 600,000 records within ONE
> table. A total of 12 tables and not quite
> 1 million records in total but enough to bog
> access down with the numerous hits.
>
> Just my 2 cents!
>
> Randy Adkins
>
>
> -----Original Message-----
> From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 10:33 AM
> To: CF-Talk
> Subject: RE: Access question
>
>
> Sure, it can "handle" simultaneous Access from many users. A
> bunny might be
> able to handle a wolf for about 2 seconds, then it dies. Same
> with Access.
> I've had sites crash every 2 minutes using Access, move it to SQL and it
> works fine.
>
> Use SQL. Don't screw with Access.
>
> AJ
>
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 10:27 AM
> To: CF-Talk
> Subject: RE: Access question
>
>
> It can handle simultaneous Access. Access is just a toned down version of
> SQL (which it sounds like you already know). You should base
> your decision
> to upsize to SQL purely on the performance of your site and size that your
> database grows to. As far as simultaneous access is concerned, obviously
> SQL will be better but may be overkill depending on the amount of traffic
> that goes through the database. In the words of someone else using this
> usergroup (I think it was Bill!) - "Don't provide a Star Trek
> solution to a
> Babylon 5 problem"
>
> Apollogies Bill if I miss quoted you!
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> ------------------------------------------------------------------
>
>
> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]]
> Sent: 12 October 2000 16:05
> To: CF-Talk
> Subject: RE: Access question
>
>
> Thanks for the quick reply.
>
> At this point I am more concerned about simultaneous access. Can it handle
> simultaneous access from many users or is SQL better for this.
>
> Thanks Andy.
>
> Robert O.
>
> >-----Original Message-----
> >From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, October 12, 2000 8:49 AM
> >To: CF-Talk
> >Subject: RE: Access question
> >
> >
> >How much data is in the table? I would be extremely surprised
> if this was
> >due to there being too much data in the table. I think the
> maximum size of
> >an Access mdb is approx 2gb but I aint sure about this. I know
> >that you can
> >have a whole load of records in a table though (millions) not that you'd
> >want to of course for performance reasons. Run some test to pull out
> >records yo know are there. If it finds them then I'll bet that the login
> >details they are using are incorrect. Are you sure that the
> error message
> >you get implies that no row was found when the query was run.
> Have you got
> >you db integrity set up so that the login details supplied make up the
> >promary key of the table?
> >
> >------------------------------------------------------------------
> >Andrew Ewings
> >Project Manager
> >Thoughtbubble Ltd
> >------------------------------------------------------------------
> >
> >
> >-----Original Message-----
> >From: Robert Orlini [mailto:[EMAIL PROTECTED]]
> >Sent: 12 October 2000 15:33
> >To: CF-Talk
> >Subject: Access question
> >
> >
> >Hello,
> >
> >I have an Access database of email login addresses in an Access
> 2000 table.
> >Outside users that have registered enter their login address and then are
> >sent via a .cfm form to a URL.
> >
> >Yesterday my .cfm form started rejecting some users saying it
> >could not find
> >their address in the table. Is it conceivable that Access is now reaching
> >its limit for what I need?
> >
> >I'm presuming now is the time to start using SQL.
> >
> >Any suggestions or hints?
> >
> >Thanks
> >
> >Robert O.
> >HW Wilson
> >
> >-------------------------------------------------------------------
> >---------
> >--
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/c
f_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>-------------------------------------------------------------------
>-----------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
