| Author |
 Topic Search  Topic Options
|
wendy_2006 
Newbie
Joined: 28 September 2007
Status: Offline
Points: 9
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Could not decrease Access Database
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?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Jeet Chowdhury
Groupie
Joined: 25 August 2007
Location: India
Status: Offline
Points: 61
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
wendy_2006
Newbie
Joined: 28 September 2007
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
javi712
Senior Member
Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
