Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    22

    File size smaller after saving

    I’m new to access.
    - I saved my first database and it was 2,176 KB
    - I saved the same file under a different name and got 704 KB
    - I saved that newest file under yet another name and got 528 KB
    - I repeated this twice more and got 548 and 534 KB.



    Is this anything to be concerned about or is Access just compressing the file? If the latter is the case, why does Access do this only when I save the entire file, as opposed to when I save the individual objects within it?

    Thanks

  2. #2
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    under the office menu you'll find in Access the option Manage -> compact and repair. This will compact and shrink your database to the smallest possible size.

    grNG

Please reply to this thread with any new information or opinions.

Similar Threads

  1. record saving twice in table
    By ds_8805 in forum Forms
    Replies: 15
    Last Post: 04-14-2010, 07:16 PM
  2. Access 2007 file size vs Excel
    By andrewalms in forum Access
    Replies: 4
    Last Post: 02-02-2010, 02:32 PM
  3. mdb file size limit
    By dr_ping in forum Access
    Replies: 1
    Last Post: 01-19-2009, 09:52 AM
  4. Replies: 2
    Last Post: 01-14-2008, 12:15 PM
  5. Replies: 2
    Last Post: 07-24-2006, 09:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums