Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Compact the access-DB

Discussion in 'Information Technology' started by Eitan M, Jul 28, 2006.

  1. Eitan M

    Eitan M
    Expand Collapse
    Guest

    Hello,

    I have Access 2000 database.

    For some reasons, sometimes I add records to the DB and sometimes I delete
    records.
    When deleting records, I see that the "DB" keep the space on the db,
    and suppose it was 100M, it is not reduced after deleting records.

    How can I compact the access-DB (after deleting the record).
    This I need by some sql statement,
    because I want that the user will have some options to compact the DB in
    external program (i.e VB 6).

    Thanks :)
     
  2. Eitan M

    Eitan M
    Expand Collapse
    Guest

    ....
    The compress could be automatic, or manually,
    but with no need to open the access environment
    (should be manually-external or automatic).

    Thanks :)
     
  3. Arthur

    Arthur
    Expand Collapse
    Guest

  4. Eitan M

    Eitan M
    Expand Collapse
    Guest

    Where is JRO ?

    Thanks :)
     
  5. Eitan M

    Eitan M
    Expand Collapse
    Guest

    Found.
    Microsof Jet and replication ...

    Seems a great example, just what I need for VB 6.0

    I'll try it.

    Thanks :)
     

Share This Page