Code database has grown . . .can't figure out which objects caused it . .

Question

I have a front end database that has grown from 6mb to 200mb over the past several months . . . I know I've added a few graphics embedded in report headings, so I removed those and it only reduced from 200mb to 50mb . . is there a way to look at objects/sizes or something to compare with the old copy to determine what caused the huge growth in size? Or better yet, compare the two databases and see what objects changed?  Thanks

Answer 1

Export each object to a seperate blank database and then compare file sizes.

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

I have a front end database that has grown from 6mb to 200mb over the past several months . . .

Hi Big Itch,

Did you try a Compact/Repair?

Imb.

Answer 3

Yes . . .the file sizes are after a Compact/Repair

Answer 4

Good idea . . .thanks . . .I'll try that. . .