Extra databases created in Access 2007

[neil40]

I converted a database from 2003 to 2007 (so it went from .mdb
to .accdb).

In 2007, I have now noticed a series of database(x).mdb (where x is
an
incrementing number) appearing in the DB directory.


Is this normal - IE do I have an option set somewhere.
If so, what is it's purpose and what triggers it.


Regards
Neil

 

[Guest]

Compact on close will do this if you don't have delete permission.

 

[neil40]

Compact on close will do this if you don't have delete permission.









- Show quoted text -

OK. Sounds fair enough. I was opening this on a laptop from a mapped
drive. Though it's only a Windows XP Home workgroup, so it surprises
me a little that I can't delete, as I can create and delete other
Office files (Word/Excel) and as it is XP Home there are only the
usual 'Share folder on network' and 'Allow network users to change
files' settings

Neil

 

[Guest]

If you can create and delete other files, you do have delete
permission.

My next guess would be a network problem, but if it is not
a problem with the 2003 version, perhaps it is related to
the new security settings in 2007?


It is still likely to be caused by compact on close (which
creates a new file, deletes the old file, then renames the
new file).

(david)

 

[neil40]

If you can create and delete other files, you do have delete
permission.

My next guess would be a network problem, but if it is not
a problem with the 2003 version, perhaps it is related to
the new security settings in 2007?

It is still likely to be caused by compact on close (which
creates a new file, deletes the old file, then renames the
new file).

(david)








- Show quoted text -

Cheers for the thoughts

I'll take a look at network and do some tests.
It's not really a problem, other than the DB is 5mb and it had created
6 copies before I spotted it, so 30Mb of copies!!!

Just wondered why it was happening.

Regards
Neil