Duplicate DB

[Guest]

I have a DB that is split (front end and back end) on my server. The front
end is only provided to my clients. I keep getting new DBs named db1, db2,
and so on in my folder where my DB is locate. Why is this happening and how
do I stop it?

Thanks
--

 

[Brendan Reynolds]

Probably the 'Compact on Close' feature. Try turning it off - assuming it is
turned on - and see if those databases stop appearing.

I'm not sure its a good idea to use that feature anyway. I prefer to do a
backup before a compact, in case anything goes wrong.

 

[John Spencer]

Do you have Compact on Close set for the database that is being duplicated?
Do you have full permissions on the directory?

Compact makes a new copy of the database, populates it, and then if all the
compact and repair operation has worked properly will delete the original
database and rename the new Db1 with the original's name. If it cannot
delete the original, finish the compact to the new db, or runs into some
other problems, it will retain the original and the new Db1. The next time
it tries to compact, it will see that DB1 is there and create DB2.