Re: FN-FORUM: ASP / Access problem

date posted 21st January 2004 15:34

Cheers for the replies,

As unlikely as 20 concurrent connections sounds, it's happened twice this
week! It's my stupid fault for using Access but I'm not really a techie, so
I don't know much about the alternatives (correction....I know bugger all).
Is it fairly straightforward to replace the Access file with something
else - don't suppose anyone knows of any decent tutes?



----- Original Message -----
From: "Norman Beresford" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, January 21, 2004 4:11 PM
Subject: RE: FN-FORUM: ASP / Access problem


>
> Hi Dan
>
> You'll probably find that's 20 concurrent connections. Which is
> probably a bit high (IIRC Access tends to throw a wobbly at around 10),
> but to be honest it's very unlikely you'll have 20 concurrent
> connections (and if you do you really shouldn't be driving your site
> with Access). If it's 20 connections full stop then it's either a
> hardcoded limit which means hacking around with the existing code to get
> round it, or move to a different forum system.
>
> No doubt someone will tell you to use mySQL instead of proposing a
> solution/telling you why it's not a problem, just ignore them.
>
> hth
>
> Norman
>
> Ps, did that link actually work for anyone?
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Dan
> Cook
> Sent: 21 January 2004 15:57
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: ASP / Access problem
>
>
>
> Hi everyone,
>
> I've had an error message come up on one of my forums (listed here:
> http://www.bsooy.com/dynamiclink/DC_solutions.asp?RECORD_KEY[DC]=ID&ID%5
> BDC%
> 5D=10)
>
> Apparently, in laymans terms, it says my ASP forum will 'pack up' every
> time 20 or more users try and log in at the same time! This is a huge
> pain in the arse and I was wondering whether anyone has any ideas on
> workarounds etc. I really don't wont to rebuild the forum from scratch.
> Is there any way that I can use something else instead of the .mdb
> database that requires very little work? text files or asp files etc ?
>
> many thanks
>
> Dan
>
>
> --
> ** Get all the Freelance Work you Can Handle *
> The Web Design Business Kit will show you proven tactics
> and strategies for marketing your business, winning bids, managing
> projects and pricing your work. Free Shipping Worldwide. Read more & get
> free chapters at: http://www.sitepoint.com/launch/b7c91e/3/4
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> ** Get all the Freelance Work you Can Handle *
> The Web Design Business Kit will show you proven tactics
> and strategies for marketing your business, winning bids,
> managing projects and pricing your work. Free Shipping Worldwide.
> Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>