Bloating Databse

P

PRAS

I have a bloating (8meg to 16 meg) BE database containing only tables is
there any way to find out which table (s) is bloating so I can try and find
source effecting table ?
 
A

Arvin Meyer

PRAS said:
I have a bloating (8meg to 16 meg) BE database containing only tables is
there any way to find out which table (s) is bloating so I can try and find
source effecting table ?
Click to expand...

Tables with OLE fields bloat more (or actually cause more bloat since they
don't actually store OLE data within the table). That would be memo,
hyperlink, picture, or object data. Forms and reports with pictures also
contribute to bloat. The biggest temporary bloating is tthe data itself. You
can clean that up regularly by compacting the database. (Tools ... Database
Utilities ... Compact and Repair)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
P

PRAS

Thanks Arvin, I am aware of msotof the information you sen tint he repaly
and hte databse does most use OLE. Graphics , objects data , compacting etc
it is just text , . Is there any way for me to find out table sizes in the BE?
 
A

Arvin Meyer

PRAS said:
Thanks Arvin, I am aware of msotof the information you sen tint he repaly
and hte databse does most use OLE. Graphics , objects data , compacting etc
it is just text , . Is there any way for me to find out table sizes in the
Click to expand...
BE?

Only manually:

Make a copy of the backend and compact it. Then delete, and compact each
table, and subtract the bytesize from each file.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top