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.
