Could not decrease Access Database
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=24562
Printed Date: 06 April 2026 at 1:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Could not decrease Access Database
Posted By: wendy_2006
Subject: Could not decrease Access Database
Date Posted: 02 October 2007 at 1:52am
|
I upgraded from WWF7.9 (Access version) to version 9.05 . Everything was Ok.
My access database was 50MB.
To reduce the size of database, I tried to delete thousands of topic, but the size of database did not decrease. Does anybody have the same problem like me?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 02 October 2007 at 8:43am
|
When you delete anything from an Access database it is not actually deleted so the size remains the same. To get the size to decrease once you delete data from it, you need to download the database, open it in Access, and use the 'Compact and Repair' tool to shrink your database size. I would also recommend looking at moving to SQL Server or mySQL as Access is not very good at coping with larger databases. ------------- 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 |
Posted By: Jeet Chowdhury
Date Posted: 02 October 2007 at 12:17pm
| how to move access to sql. with all relation ship and default value. cause when i moving using odbc. all relation and default value of database lost. |
Posted By: WebWiz-Bruce
Date Posted: 02 October 2007 at 12:20pm
|
It all depends on what options you use and how you do it. The simplest way is to upsize the database from Access 2007 instructing it to create a new database on the SQL server and making sure that you select all the correct options so that default values are also carried across. It is often different each time so you just need to experiment. ------------- 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 |
Posted By: wendy_2006
Date Posted: 02 October 2007 at 8:37pm
Thank you very much, -boRg- . I tried and it worked for me.
I'll plan to move to SQL Server ASAP.
But I have another question: What is the limit of access database?
For examble, how many record, topics? or the size of database?
|
-boRg- wrote:Posted By: javi712
Date Posted: 03 October 2007 at 1:53am
| There is really no defining limit, some people get lucky and can go far with an access database, for others, it gets corrupted with no prior notice and lose everything. My access database actually reached around 350MB once, to the surprise of everyone, but shortly thereafter it got corrupted. Luckily I had a back up and was able to upgrade to SQL. No problems since. |
Posted By: WebWiz-Bruce
Date Posted: 03 October 2007 at 7:34am
|
If you are using a shared web host you should also contact them, I know allot of shared web hosts place a limit on the size of Access databases, often below 20MB.
------------- 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 |