RyanESmith7 Posted February 29, 2016 Share Posted February 29, 2016 (edited) I've taken an existing database and deleted all of the records out of it to create a sort of "template" database for other purposes. The original database had a sizable amount of records, but they're all gone... However this empty database is over 200MB! When I did this same exercise a few months ago, it was around 70MB. I've made minimal schema changes, I don't have much for graphics, and I have saved a compacted copy and it is still over 200MB. Does anyone have any ideas for shrinking that up further? I'd like to get it below 100MB to make it transferable to an iPad. Thanks, Ryan Edited February 29, 2016 by RyanESmith7 Link to comment Share on other sites More sharing options...
Lee Smith Posted February 29, 2016 Share Posted February 29, 2016 Did you try saving the database as “Smaller”? Link to comment Share on other sites More sharing options...
RyanESmith7 Posted February 29, 2016 Author Share Posted February 29, 2016 Yes, Lee, did that. That took it from 206MB to 200MB. LOL Link to comment Share on other sites More sharing options...
bruceR Posted February 29, 2016 Share Posted February 29, 2016 Did you save it as clone? Link to comment Share on other sites More sharing options...
RyanESmith7 Posted February 29, 2016 Author Share Posted February 29, 2016 Perfect! I had not tried Clone cause I wanted to hang on to 16 records in one table, but doing that brought it down to 19MB! Re-imported my missing records and I'm good to go. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2972 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now