Web Wiz Forums - how much records for access version?

Print Page | Close Window

how much records for access version?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15324
Printed Date: 13 April 2026 at 6:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: how much records for access version?

Posted By: RAVALON
Subject: how much records for access version?
Date Posted: 01 June 2005 at 2:31pm

Hello....i'm using Access version of this beautiful forum....

I would to know how much records could contain first of collapse.....and if is possibile how much contemporaniously connection could support...

tks....

Replies:

Posted By: dj air
Date Posted: 01 June 2005 at 2:46pm

access can support about 20 concurrent connections but is likely to corrupt.

with the ammount of the database, there are some that hold lotd im not sure on the actual figure but if you are thinking of having a quite a big forum, i would recommend going to SQL server first off, as it will be easier in the long run.

Posted By: RAVALON
Date Posted: 02 June 2005 at 7:37am

but cannot you tell me how much records could contain at max first of collapse ?

I think i have a big traffic, and i'm going to convert this forum to mysql, but i would know how much time i have first of Access collapse ...

Posted By: dj air
Date Posted: 02 June 2005 at 7:45am

there is not an exact figure but i've seen sites running on access with 40,000 posts etc. and quite a few members.

the forum wont run on MySQL in its current staus.

only on Microsoft Access and Microsoft SQL Server.

Posted By: sfd19
Date Posted: 02 June 2005 at 8:37am

60,000+ posts and an Access DB of 150 MB. No problems, so far. 6 hours backup, of course.

And no, we can not switch to MSSQL.

-------------
Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net

Posted By: RAVALON
Date Posted: 02 June 2005 at 8:43am

i know.....but i'll do a personal conversion...

tks for your answer