Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    London, Gtr London, England
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Database Size (Access97 SP2)

    Hi,
    I have a database that is 42MB in size. Is it possible to find out how this is distributed across, tables, queries, forms and reports?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access Database Size (Access97 SP2)

    You could estimate it, but what are you actually trying to accomplish? And is that the size after it's been compacted?
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Database Size (Access97 SP2)

    A rough method would be to create a new database and import tables. See how big. Repeat with queries ...

    If you have the data and the interface (tables / forms, reports) in one database then that is not a recommended way to go. Split it into two. The backend contains the tables. The front end all others with the tables linked. Why? Easier to maintain and you can have the front end on many PC's simultaneously working with one back end DB (data sharing).

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Database Size (Access97 SP2)

    As you work with a database, the size only increases - the space occupied by deleted temporary objects, records etc. is not released automatically. Compacting the database (Tools/Database Utilities/Compact Database) will take care of this.

    If you have lots of code, decompiling and then recompiling and compacting the database can reduce the size of your database even further. See <post#=44732>post 44732</post#> and <post#=44865>post 44865</post#> for instructions on decompiling. Decompiling removes invisible rubbish left over from editing code that you can't get rid of by just compacting.

    Andy's suggestion of importing database objects of one type into a new database and comparing file size is one way of getting a rough estimate (don't forget to compact the target database). Another way is to make a copy of the database and *remove* database objects - in that case you *must* compact to reclaim the space.

  5. #5
    New Lounger
    Join Date
    Sep 2002
    Location
    London, Gtr London, England
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Database Size (Access97 SP2)

    Thanks for all the replies.

    Why do I want to do this? I

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access Database Size (Access97 SP2)

    Have a look at <post#=209335>post 209335</post#>
    Regards
    John



  7. #7
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Access Database Size (Access97 SP2)

    <P ID="edit" class=small>(Edited by MarkD on 07-Jan-03 18:41. Added attachment in A97 format.)</P>In a recent post I attached a sample db (A2K format) that allows you to print the document properties of all database objects to a text file. These properties include Date Created, Last Updated, and Description. This may or may not be useful. You should also take a look at the built-in database Documenter (Tools menu, Analyze) which generates a detailed report of all selected database objects & their attributes. Link to previous post:

    Post: 210105 Re: Querying form object attributes (2000)

    PS: Just realized subject line sez Access 97!! Have attached sample db converted to ACC 97 format if interested.

    HTH
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •