Compact and Repair Error

[PJFry]

I am tyring to compact and repair a database. After a start the process a
new db shows up in the source folder, usually db1. No problem there. When
the db is done, the size of the 'compacted' db is the same. db1 still exists
and it is actually the compacted db. So when it is all said and done, I have
two db's, db1 and the original. db1 is the compacted version of the original.

Any thoughts on how to fix the process so the db1 replaces the original db?

Thanks!
PJ

 

[Guillermo_Lopez]

I am tyring to compact and repair a database.  After a start the processa
new db shows up in the source folder, usually db1.  No problem there.  When
the db is done, the size of the 'compacted' db is the same.  db1 still exists
and it is actually the compacted db.  So when it is all said and done, Ihave
two db's, db1 and the original.  db1 is the compacted version of the original.

Any thoughts on how to fix the process so the db1 replaces the original db?

Thanks!
PJ

Are you using Tools>Database Utilities>Compact and Repair in the
menu's??

Technically, this should rename db1 to the original name after
deleting the original. If it fails to compact correctly, it will not
delete the original DB.

 

[Pete D.]

1. You don't have delete rights
2. Your using Vista and haven't read about some issues
3. Your security isn't right in some way
3. sorry, sounds like security see for how to fix security, yea, I feel
guilty passing your questions but...one less for them to answer again.
http://allenbrowne.com/tips.html