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.
