Database duplicated on exit

L

Linda

I have one database which has started creating a copy each time I exit from
it. I have the original database then a series of copies starting at db.1.
How do I stop this from happening? Thanks.
 
D

Douglas J. Steele

Sounds as though you've set the database up to Compact on Close, and you
don't have the appropriate permissions on the folder where the database file
exists. (most likely no Delete permission)

Compact on Close is seldom (if ever) a good idea. Your application should be
split into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing the table and relations), even,
in my opinion, for single-user databases. Generally, it'll be the back-end
that needs the compacting, and Compact on Close will only compact the
front-end. And in the event that your front-end has grown to the point where
you think it should be compacted, replacing it with a new copy makes more
sense.
 
Top