Microsoft Access database too large – Can I divide my Access file?

5 pts.
Tags:
Database programming
Microsoft Access
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????

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following