Duplicate DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rshed - 21 Nov 2006 10:41 GMT

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
--

Reply to this Message

Brendan Reynolds - 21 Nov 2006 12:24 GMT

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.

Signature

Brendan Reynolds
Access MVP

>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,
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

John Spencer - 21 Nov 2006 12:28 GMT

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.

>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,
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message