[thelist] Access db for discussion forum

[Seth Bienek]

Hey Ol,

Access is good for about 7 concurrent connections.  If you are not running
more than that many simultaneous clients, you should be OK.  Access is
alright for small, portable apps, but anything that you may want to scale up
should be built around something more robust.

I have run entire database-driven websites off CF and Access without too
many problems.  Would I do it now?  No.

My 2.. Uh.. Well, you know..

Seth

------------------------------------
Seth Bienek
Independent ColdFusion Developer




> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Oliver Lineham
> Sent: Tuesday, August 29, 2000 3:42 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] Access db for discussion forum
>
>
> Quick question,
>
> A customer wants a web-based discussion forum (closed off to
> all but their
> hundred or so customers).  Unfortunately the only database I
> can use on the
> server is Access (any version).
>
> I know this is less than desirable. But is there any really
> outstanding
> reasons why this is a super bad idea?
>
> Perhaps I should store the forum messages in a separate mdb
> in case Access
> decides to shit its pants and corrupt the database? (database
> is used for
> other stuff not just this forum).   Or would this just be making
> unnecessary trouble for me when I try to marry the data at run-time?
>
> The scripting is ColdFusion not that it should make a difference.
>
> Ta muchly,
>
> </ol>
>
> ____________________________________________________
>      v i b e   m e d i a    http://www.vibe.co.nz/
>   po box 10-492              wellington, new zealand
>   phone +64 21 210-7845         oliver at lineham.co.nz
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
>