Microsoft Access database too large – Can I divide my Access file?
Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now and will not allow me to data input anymore. therefore i need to remove the program from the military system and continue on my personal laptop. However the military PC's im using do not allow USB usage and only possess CD burners not DVD, the Program is to large to go on a CD, i can not install anything to help on the system i.e Winzip, Nero etc. So what i need to know is if access will allow me to cut some of the work onto an empty database burn the slices (2-3) install them on my laptop and patch them back togther as one document????
Software/Hardware used:
Software/Hardware used:
ASKED:
December 13, 2008 7:39 PM
UPDATED:
December 17, 2008 12:15 AM
RELATED QUESTIONS
- How to add and / or delete files to modify a program's installation?
- Problem accessing the Desktop and My Documents using Roaming Profiles / Redirects
- How can I replace my driver files?
- Can't use database within Workgroup with Windows XP clients
- Classic Applications Display as "Unix Executable Files" in Tiger and Don't Load
Answer Wiki:
Have you tried a Windows built-in zip compressor? Or how about creating 3 mdbs each containing one third of data? copy first third of probably one BIG table in a mdb to the first temp mdb. And this is the final one: try asking your administrator for some more privileges.
To see all answers submitted to the Answer Wiki: View Answer History.
Have you compressed the database? Access database is known to be inefficient is data space management. Before trying to zip the database – you may try to compress via Access tools. In Access 2007 … Click Manage (under the Office button) then select Compact and Repair. Follow the instructions – (be sure to type in a new name for the compacted version). I have seen drastically reduced space need after the compress.
You’re barking up the wrong tree. Access has a size limit of 2GB so you are at the limit. You can check this out here:
If you need to go larger you might want to consider either a different DBMS or, as has been said previously, break up the database into parts (probably not the best solution.)