Access is designed for SMALL offices where the number of read/write operations at any
one time are relatively low. The size of the database isn't so much of a concern as
opposed to the complexity of it.
SQL is your upgrade path when you've exhausted all the performance upgrades you can do
on your code.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 8:05 AM
> 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/[email protected]/
> >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/[email protected]/
>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/[email protected]/
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/[email protected]/
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.
