Web Wiz Forums - Access DB and Archiving

Print Page | Close Window

Access DB and Archiving

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=7190
Printed Date: 04 April 2026 at 5:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access DB and Archiving

Posted By: bruce
Subject: Access DB and Archiving
Date Posted: 12 November 2003 at 7:50am

About how big can an access DB get before you will begin to see problems with the forum? Right now my access db is around 45 mb and it seems to be ok, however it does seem to be getting a little slower.

Is it difficult to convert an access db to MS SQL?

Is there anyway to archive posts. I'd like to archive each years posts, i.e. 2003, 2004 etc. and if so will it improve the forum performance?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 November 2003 at 8:18am

The size an Access database can be depends on the server. Processing power, memory, how many other sites and servers loads all play parts in this.

Access has an upsize wizard to upsize the database to MS SQL server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting