Now, I *had* heard of Access 2K having slight problems with simultanious requests.
If, when you set up your ODBC source, you limit concurrent connections to 1, that will
keep that problem from happening. Liaible to slow you down, some, though. All
depends on how much traffic you're getting, I think.
Willy
>>> [EMAIL PROTECTED] 10/12/00 8:57:04 AM >>>
Fair enough....but it all depends on what many is.
If a client comes to me asking for a small, half a dozen page data driven
web site where there is very little dynamic content why would I suggest
using SQL. The price of the DB software would probably be more than the
total development for the site! There would be litte or no danger of Access
bringing down CF providing that traffic was monitored....sure if it runs
like a dog because of loads of hits then move to SQL
I developed a small site for a TV company which had thousands of hits a day
while the series was running. They updated the content on the site by
changing the samll amount of data stored in an Access database. Site worked
fine...no probs. SQL would have been a coplete overkill
I disagree with your comment "Access is NOT by strict definition a multi
user database. SQL is." Access is a multiuser database. Just that SQL is a
better one
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:47
To: CF-Talk
Subject: RE: Access question
Hey Andy,
I refer you to his original question: "Can it handle simultaneous access
from many users or is SQL better for this".
His "problem" was many users, not a small db.
Nonetheless, I agree with Bill's quote. But ask yourself a question, why
would you ever propose or use a solution that MIGHT bring CF down? I've
never heard of SQL Server bring CF down. I've personally experienced Access
bringing CF down. Access is NOT by strict definition a multi user database.
SQL is.
AJ
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 10:39 AM
To: CF-Talk
Subject: RE: Access question
Aaron - I refer you to Bill's excellent quote:
"Don't provide a Star Trek solution to a Babylon 5 problem"
There's no point forking out for a SQL internet license if you can use
Access for free and it does the job you need it too. Don't get me wron - I
admit SQL is a thousand times better than Access but if you've only got a
tiny database, what's the point?
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 15:33
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/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.
----------------------------------------------------------------------------
--
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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
