Bloating Databse

[Guest]

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 ?

 

[Arvin Meyer]

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 ?

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

 

[Guest]

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?

 

[Arvin Meyer]

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?

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