Compact & Compress Vs New Database

Discussion in 'Microsoft Access Database Table Design' started by Gary, Jul 8, 2003.

  1. Gary

    Gary Guest

    Hi:

    I have been compacting and and compress by mdb database
    for sometime now. I just noticed that my mdb database has
    been growing because of changes, etc. It is currently
    about 59MB in size.

    I created a new database, and imported everything over
    from the old database to the new one. I noticed that the
    overall size of the database is much smaller than the 59MB
    in size.

    I checked out the new database and everything works with
    nothing missing.

    Can someone explain what is happening?????
    I am interested.


    Thank You,

    Gary
     
    Gary, Jul 8, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. zuhairi che din

    compact database

    zuhairi che din, Jul 30, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    493
  2. Marty

    Post SP4 - Cannot open databse msg when running compress/repair

    Marty, Aug 7, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    529
    Marty
    Aug 7, 2003
  3. Marty

    "Cannot open database" msg during Compact and Repair

    Marty, Aug 15, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    597
    Marty
    Aug 15, 2003
  4. ALY

    CAN NOT COMPACT DATABASE ANYMORE

    ALY, Aug 28, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    3
    Views:
    216
    GVaught
    Aug 28, 2003
  5. John C.

    Compact the Database

    John C., Dec 6, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    227
  6. Mike

    Problem with compact and repair database

    Mike, Dec 28, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    214
    Allen Browne
    Dec 28, 2003
  7. Guest

    Compress Database

    Guest, Feb 9, 2005, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    253
    Guest
    Feb 14, 2005
  8. Jack Gordon via AccessMonster.com

    Compact database

    Jack Gordon via AccessMonster.com, Mar 30, 2005, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    198
    Douglas J. Steele
    Mar 31, 2005
Loading...