Compacting a DB

[Cat]

I know I'm missing something very, very simple. I can't seem to figure out
how to run an event that will compact another DB, keep the same name and
locale. Can anyone help? Thanks.

cat

[Lt. IJ]

i got the same scenario recently.
what i did was the folowing:

-if database is currently used, close it (must open it exclusively).
-compacting a database produces another file e.g. cpdb.mdb (like a mirror)
but compacted.
-get that filename or path of that cpdb.mdb
-delete or backup the original database
-rename cpdb.mdb to the name of original database

this works for me, nevertheless

"Cat" <cat1173@hotmail.com> wrote:
>
>I know I'm missing something very, very simple. I can't seem to figure
out
>how to run an event that will compact another DB, keep the same name and
>locale. Can anyone help? Thanks.
>
>cat

[Cat]

Hey. Thanks for the info Jerry! I'll work with it and see what happens.
Or I can just get the user to go in and compact couple times a week! hehe
Thanks again!

cat


"Lt. IJ" <jerryrflores@yahoo.com> wrote:
>
>i got the same scenario recently.
>what i did was the folowing:
>
> -if database is currently used, close it (must open it exclusively).
> -compacting a database produces another file e.g. cpdb.mdb (like a mirror)
>but compacted.
> -get that filename or path of that cpdb.mdb
> -delete or backup the original database
> -rename cpdb.mdb to the name of original database
>
>this works for me, nevertheless
>
>"Cat" <cat1173@hotmail.com> wrote:
>>
>>I know I'm missing something very, very simple. I can't seem to figure
>out
>>how to run an event that will compact another DB, keep the same name and
>>locale. Can anyone help? Thanks.
>>
>>cat
>