Web Wiz Support and Community Forums : Question about Access database

Web Wiz Support and Community Forums : Question about Access database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 02:35:06 +0000 Mon, 11 Sep 2006 16:51:22 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21259 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Question about Access database : Thanks againforyour precious advices.....so...]]> https://forums.webwiz.net/question-about-access-database_topic21259_post113924.html#113924 Author: stefanoIT
Subject: 21259
Posted: 11 September 2006 at 4:51pm

Thanks again for your precious advices.....so I'll daily backup the database...so I'll sleep well in the night!!

Bye bye!
Stefano - Italy

]]> Mon, 11 Sep 2006 16:51:22 +0000 https://forums.webwiz.net/question-about-access-database_topic21259_post113924.html#113924 <![CDATA[Question about Access database : It's very tricky to tell...]]> https://forums.webwiz.net/question-about-access-database_topic21259_post113915.html#113915 Author: WebWiz-Bruce
Subject: 21259
Posted: 11 September 2006 at 2:35pm

It's very tricky to tell with Access as it is a flat file so it's like storing your data in a text file rather than a database, the problem then is that it's very easy for the data in the flat file to become corrupted.

I would only every recommend using Access if you have no other choice.

If you do decide to use Access, if you open the file in MS Access on your PC there is a compact and repair tool in the tools menu which does often fix issues with corruptions in the Access file, also you should make backups of your Access database file incase you can not recover from a corruption to the Access file.
]]> Mon, 11 Sep 2006 14:35:56 +0000 https://forums.webwiz.net/question-about-access-database_topic21259_post113915.html#113915 <![CDATA[Question about Access database : Ok, thank you very much for the...]]> https://forums.webwiz.net/question-about-access-database_topic21259_post113904.html#113904 Author: stefanoIT
Subject: 21259
Posted: 11 September 2006 at 12:39pm

Ok, thank you very much for the answer.....!

So, if I have got a forum that has got 200 registred users and 700/800 messages in total, with the Access database I could not have any problem.....the only important thing is the number of users on-line at the same time, that it mustn't be too high, is it right?

Stefano - Italy

Edited by stefanoIT - 11 September 2006 at 12:42pm]]> Mon, 11 Sep 2006 12:39:06 +0000 https://forums.webwiz.net/question-about-access-database_topic21259_post113904.html#113904 <![CDATA[Question about Access database : I have had reports from people...]]> https://forums.webwiz.net/question-about-access-database_topic21259_post113894.html#113894 Author: WebWiz-Bruce
Subject: 21259
Posted: 11 September 2006 at 8:39am

I have had reports from people that they have the Access version with over 200,000 posts and over 15,000 users.

However, Access is an office flat file and not a real database management system so with the amount of read and writes required for a forum can easily get overloaded and become corrupted.

I would not run an Access database for a forum above 10Mb and if expevct more than a handful of users per day I would look at using the SQL Server or mySQL versions.
]]> Mon, 11 Sep 2006 08:39:17 +0000 https://forums.webwiz.net/question-about-access-database_topic21259_post113894.html#113894 <![CDATA[Question about Access database : Hi, I'm a new italian user...]]> https://forums.webwiz.net/question-about-access-database_topic21259_post113856.html#113856 Author: stefanoIT
Subject: 21259
Posted: 09 September 2006 at 9:28pm

Hi, I'm a new italian user of the beautiful Web Wiz Forum!

First of all, excuse me if my English is not very good.....but it isn't my current language

I opened this Topic because I've got a small web wiz forum with access database.....so I would like to know: how many registred users, topics and messages can I have maximum with this type of database?......and what could happend if my forum became bigger.... could I have loss of data?

Thank you for an answer......

Stefano - Italy

Edited by stefanoIT - 09 September 2006 at 9:35pm]]> Sat, 09 Sep 2006 21:28:26 +0000 https://forums.webwiz.net/question-about-access-database_topic21259_post113856.html#113856