>>>When a record was deleted from an Access Table, is it
>>>permanently being removed or we still can "undo" the deleted
>>>record? Because I discovered that the Database size didn't
>>>change before and after the deletion of 10,000 records.
>>>Or is it like Dbase, have to issue a PACK command to permanently
>>>remove the records? Pls advise, thanks.
>>
>>You can't undelete it but you need to compact your database in order to claim lost bytes.
>>
>>You can use the CompactDatabase method of the DAO DBEngine object.
>
>Could you provide me some guide lines on how to go about achieving it?
>I'm pretty new in VB programming, thanks for your help.

Common, read the help file or this article: http://support.microsoft.com/support/kb/articles/Q192/1/53.ASP?LN=EN-US&SD=gn&FR=0