|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-25-2011, 10:42 AM
|
#1 |
|
Member (10 bit)
Join Date: Dec 2003
Posts: 516
 |
MS Access 2000
Hello all,
We have here at work an MS Access Database that is about full to capacity. We want to compact the database. The issue we are running into is the fact that Access will not allow us to compact the database. If we try to delete any portions of the database we are returned an invalid argument. The same occurs when we try to do a normal compaction of the database. Is there any other way of removing files or deleting files from the database? Thanks Chris
__________________
|Intel i5-2500k| |Gigabyte Z77X-UD5H| |1TB WD Cavier Black| |EVGA GeForce GTX570SC| |8GB Vengeance 1600| |Antec High Current Gamer 750 Watt| |Logitech G19| |Razer DeathAdder| |Windows 7 Pro||Logitech G51 speakers| |Lite On DVD burner||Logitech G35 Headset| |Cooler Master HAF 932| |Hyper 212 Evo||2 x Kingston HyperX 120GB SSD| |
|
|
|
08-25-2011, 11:40 AM
|
#2 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,384
|
The size limit for an access database is 2GB. It sounds like you may have outgrown it.
To options--start archiving data, or go with a real database solution, such as MSSQL, MySQL, PostgreSQL, or Oracle RDBMS. Archive Access data - Access - Office.com
__________________
There are two secrets to staying young, being happy, and achieving success. You have to laugh and find humor every day, and you have to have a dream.
|
|
|
|
08-27-2011, 01:27 PM
|
#3 |
|
Member (10 bit)
Join Date: Dec 2003
Posts: 516
|
Force, does this apply to MS Access 2000 as well. I know 2000 is very out dated and unfortunately we must like using old version of programs at my engineering firm. In any event, we have compressed the files numerous times, and just cannot do it anymore as we are at the limit as you stated.
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
