Rabu, 27 Juli 2016

[MS_AccessPros] Database Size


I am working on a new database. It is a linked database and is relatively small: 10 tables, 10 forms, a few reports. All of a sudden the db 'ballooned'  from approx 10 MB to 112 MB, I ran a compact and repair and it went down to 42MB. I then imported all objects to a new database. but the new database is even larger:130MB.

After I compacted and repaired, i also made a new MDE. The old MDE was 3.2 MB, the new one is 38MB.

This happend as I was in middle of working on a form: redefining the child/master definition on a subform to a form. the 'wheel' starting spinning for a very long time and the database inflated.

I went back to a saved copy , and redefined the the child/master definition. I compacted the DB and it is now 5MB.

What did I do? What happended? I am looking to avoid this in the future.



Posted by: sarahk@schemesoftware.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.



Tidak ada komentar:

Posting Komentar