Tech Support Guy banner
Status
Not open for further replies.

Splitting an MS Access Database

886 views 1 reply 2 participants last post by  Anne Troy 
#1 ·
I have a huge MS Access 2000 database (about 33meg in size). How do I split that up into 10meg "chunks?" Or is that even possible?
 
#2 ·
33M is not that big for an Access database, but they are generally stored on a server. I assume you have this one at home and suspect that your tables are not properly normalized. Why don't you export one of them, preferably your biggest one and email it to me (zipped probably) and I'll check it out for you.

Otherwise, you could create a new blank database and export a table or two to it, then link the table to your existing database. However, linked tables can only be changed in its own database.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top