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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. zuhairi che din

    compact database

    zuhairi che din, Jul 30, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    514
  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:
    611
    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:
    635
    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:
    244
    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:
    256
  6. Mike

    Problem with compact and repair database

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

    Compress Database

    Guest, Feb 9, 2005, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    293
    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:
    246
    Douglas J. Steele
    Mar 31, 2005
Loading...