compact a mdb

[00KobeBrian]

I tried to run compact on a mdb. After the run, I get an error message
"Record can't be read; no read permission on 'D:\ the mdb' ". Then db1.mdb
is created. But the original mdb still got same size. Does this mean the
original mdb is compacted to db1.mdb ? What does this error mean? Is it
normal? please help me. Thanks.

 

[Keith Wilby]

I tried to run compact on a mdb. After the run, I get an error message
"Record can't be read; no read permission on 'D:\ the mdb' ". Then db1.mdb
is created. But the original mdb still got same size. Does this mean the
original mdb is compacted to db1.mdb ? What does this error mean? Is it
normal? please help me. Thanks.

When you compact, a new mdb is created, the old one deleted and the new one
renamed to the name of the old one.

HTH - Keith.
www.keithwilby.com

 

[Ron2006]

I would check your permissions on the drive, and then try the compact
and repair again.

 

[Ron2006]

I would check your permissions on the drive, and then try the compact
and repair again.

 

[00KobeBrian]

I am running this compact on my local drive and believe there is no
permission issue. May I know which permission I should check other than OS?
Thanks.

 

[Ron2006]

And the other obvious question. Have you tried it again.

I have often received error messages that have stopped the compact, but
simply re-trying it has been successful. It is worth a try.