Compact the access-DB

[Eitan M]

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

 

[Arthur]

Ayon kay Eitan M:

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

Thanks

have a look at this site.
http://visualbasic.ittoolbox.com/do...repair-access-database-with-visual-basic-2903

 

[Eitan M]

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

Thanks

 

[Eitan M]

Where is JRO ?

Thanks

 

[Eitan M]

Found.
Microsof Jet and replication ...

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

I'll try it.

Thanks