I think here we are having some confusion. If you want
to compact mdb file using VBA module, first I would
recommend you to keep database table in seperate mdb
file and your VBA code in another mdb file with link
to previous tables. This way you can compact database
thru vba code.

Hope this will help you.
Harshang

--- goran.osterman@t... wrote:
> Yoel,
> You have to do a compress of the DB. During this
> process, the actual .mdb
> file is replaced with a newly created file. You end
> up with the same
> filename, but a different physical file.
> 
> Regards, Göran
> 
> -----Ursprungligt meddelande-----
> Från: Yoel Pedersen [mailto:y.pedersen@g...]
> Skickat: den 18 februari 2002 09:53
> Till: professional vb
> Ämne: [pro_vb] Access 2000 - compress .mdb file
> after deletion of
> records
> 
> 
> Using Access 2000, the .mdb file doesn't shrink its
> size automatically
> after deletion of records. How can I programatically
> shrink its size?
> 
> Any suggestions appreciated.
> 
> Thanks in advance,
> 
> Yoel Pedersen
> 
> $subst('Email.Unsub').
> 
> 
$subst('Email.Unsub').


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com