Web Wiz Support and Community Forums : Could not decrease Access Database

Web Wiz Support and Community Forums : Could not decrease Access Database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 13:38:23 +0000 Wed, 03 Oct 2007 07:34:31 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24562 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Could not decrease Access Database : If you are using a shared web...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128297.html#128297 Author: WebWiz-Bruce
Subject: 24562
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.]]> Wed, 03 Oct 2007 07:34:31 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128297.html#128297 <![CDATA[Could not decrease Access Database : There is really no defining limit,...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128292.html#128292 Author: javi712
Subject: 24562
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.]]> Wed, 03 Oct 2007 01:53:23 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128292.html#128292 <![CDATA[Could not decrease Access Database : -boRg- wrote:When you delete...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128288.html#128288 Author: wendy_2006
Subject: 24562
Posted: 02 October 2007 at 8:37pm

-boRg- wrote:

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.

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?

]]> Tue, 02 Oct 2007 20:37:43 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128288.html#128288 <![CDATA[Could not decrease Access Database : It all depends on what options...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128268.html#128268 Author: WebWiz-Bruce
Subject: 24562
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.
]]> Tue, 02 Oct 2007 12:20:01 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128268.html#128268 <![CDATA[Could not decrease Access Database : how to move access to sql. with...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128266.html#128266 Author: Jeet Chowdhury
Subject: 24562
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.]]> Tue, 02 Oct 2007 12:17:48 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128266.html#128266 <![CDATA[Could not decrease Access Database : When you delete anything from...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128248.html#128248 Author: WebWiz-Bruce
Subject: 24562
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.
]]> Tue, 02 Oct 2007 08:43:50 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128248.html#128248 <![CDATA[Could not decrease Access Database : I upgraded from WWF7.9 (Access...]]> https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128242.html#128242 Author: wendy_2006
Subject: 24562
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?

]]> Tue, 02 Oct 2007 01:52:06 +0000 https://forums.webwiz.net/could-not-decrease-access-database_topic24562_post128242.html#128242