Compact the access-DB

#1 (**permalink**) 28-Jul-2006, 08:14 AM

Hello,

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10573-compact-the-access-db.html
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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10573

#2 (**permalink**) 28-Jul-2006, 08:14 AM

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

Thanks

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10573

#3 (**permalink**) 28-Jul-2006, 08:14 AM

Ayon kay Eitan M:
> ...
> The compress could be automatic, or manually,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10573
> 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/doc...ual-basic-2903
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10573

#4 (**permalink**) 28-Jul-2006, 08:14 AM

Where is JRO ?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10573

Thanks

#5 (**permalink**) 28-Jul-2006, 08:14 AM

Found.
Microsof Jet and replication ...

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10573
Seems a great example, just what I need for VB 6.0

I'll try it.

Thanks