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/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.
