Database is huge, help

[maw230]

How can I find which objects are taking up so much space in my db? Is there a way to sort by size?

 

[pbaldy]

Have you done a compact/repair? It can reduce the size significantly if you haven't done one in a while.

 

[maw230]

Have you done a compact/repair? It can reduce the size significantly if you haven't done one in a while.

Yes, I've done several today. Each one after I find and delete and old, unused table. I'm still at 1.2 gb.

 

[pbaldy]

You might also try a decompile, but are you storing images or other objects in the db? Earlier versions of Access didn't handle that very well, and the database would bloat far in excess of the size of the objects.

 

[maw230]

You might also try a decompile, but are you storing images or other objects in the db? Earlier versions of Access didn't handle that very well, and the database would bloat far in excess of the size of the objects.

No images or other. And most of the larger tables are stored on the backend. I think that I ran an overly large make table query one day, and if I could look at my tables by size I could easily find it.

 

[pbaldy]

For pure data to get it that large it would be millions of records. Offhand I don't know of a way to get table by table sizes in Access. It's not in MSysObjects.

 

[maw230]

For pure data to get it that large it would be millions of records. Offhand I don't know of a way to get table by table sizes in Access. It's not in MSysObjects.

I've been known to have tables that big
I'm sure I'll track it down. Thanks for the help!

 

[pbaldy]

Post back if you figure out a way to get the sizes. I'd be interested to learn it.

 

[Galaxiom]

This page has a script in post 7. Something of a kludge but effective none the less. I don't see any possibility of an alternative. It exports each table individually to a new database and reports the difference in filesize between that and and an empty database.

http://www.utteraccess.com/forum/Determine-Table-Size-t1938952.html