Re: Access Tables -- Size and Issues

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 08:38:18 -0500

I don't think you can find the size of a table. It just does not work that
way. I guess you could make a copy of your file and look at the size, then
delete the table, compact, and look again. Parts of the table,
relationships, data, etc. are stored in various places in the file. Access
does not really break the actual file on your disk into logical units that
correspond to the objects you see when you open the database.

As far as compacting, you don't compact an object, you compact the actual
file. Since all your tables are in one file, you can't compact just a
portion. Since it only takes a few seconds to compact a file, I'm not sure
why it would matter. Also, when it compacts, it only takes care of extra
space in the file that can be removed. It should take the same amount of
time whether you compact the changed objects, or all. In my experience,
compacting deals more with design changes to your database and only makes
small differences when you are simply adding data.

Rick B

"forevergrateful" <forevergrateful@yifan.net> wrote in message
news:uX3T6nmiEHA.636@TK2MSFTNGP12.phx.gbl...
I have a few simple questions:

1. How can I know the actual size in KBs of each table in my database?

2. Is there a way to force a database attached to a program I've written in
VB to regularly compact just certain tables rather than the whole database
since certain tables have data added and deleted continually while most of
the tables remain static?

Thanks for any assistance the group can provide.

Relevant Pages

  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access crashes when opening form
    ... Allen Browne - Microsoft MVP. ... You were correct in suspecting SP3. ... I've also had a problem with "compact on close" not working (it ... database works correctly there. ...
    (microsoft.public.access.forms)
  • Re: Compacting Backend Access Databases
    ... when I ran the procedure to compact ... use of the back-end database. ... Dim strBackendPathAndName As String ...
    (microsoft.public.access.modulesdaovba)