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.

 

[John Vinson]

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.

You need full Read, Write, Create and Delete permissions on the folder
containing the database for this to work.

The compaction process does indeed work by creating a new database
named db1.mdb (or db2.mdb if there already is a db1, etc.); copying
everything into it; deleting the old database and renaming db1. This
process got hijacked due to your windows permissions.

John W. Vinson[MVP]