Extra DBs created

[Gretchen Hembree]

We have a DB that I secured using the wizard a few months ago. Over time I
have had to add, delete or change a few of the user accounts.

I cannot pin down when or why, but in the folder where the DB is stored
extra dbs have been created. They are all named db1, db2 etc. We are now at
db29.

I am not too familiar with Access and the security side effects. Can
someone explain why these DBs are being created? Should I delete them or
leave them alone? All the sizes vary.

Currently all the users have Full Permissions. I am thinking maybe we
should just unsecure the db and go back to the way it was for years prior,
but a quick search is leading me to believe that is easier said than done.

This DB is added to by approx. 10 users. It only has 15 or so tables (all
records are being recorded in just one table the rest are for drop down
fields.) They do have about a hundred different queries set up that are used
by the different users to enter appointments, view appointments, etc. by
contract, etc.

We know we aren't using this to it's full advantage, but it has gotten us
through for the last 10 years. (The current version is Access 2003.)

Thanks for any help! ~Gretchen

 

[S Panja]

An extra database is created with a numerical suffix incremented by one each
time the original database is compacted on close [as defined in Tools |
Options | General] but the compaction is not written back to the original
database successfully as at least one user is logged into the original
database. These extra databases may be deleted.
--
http://panjas.org
http://www.linkedin.com/in/spanja

If the reply is helpful or is the answer, click Yes next to
Was this post helpful to you?
and / or
Did this post answer the question?

 

[Gretchen Hembree]

Thank you! I do have Compact on Close set up. This makes me feel much more
comfortable.

An extra database is created with a numerical suffix incremented by one each
time the original database is compacted on close [as defined in Tools |
Options | General] but the compaction is not written back to the original
database successfully as at least one user is logged into the original
database. These extra databases may be deleted.
--
http://panjas.org
http://www.linkedin.com/in/spanja

If the reply is helpful or is the answer, click Yes next to
Was this post helpful to you?
and / or
Did this post answer the question?

We have a DB that I secured using the wizard a few months ago. Over time I
have had to add, delete or change a few of the user accounts.

I cannot pin down when or why, but in the folder where the DB is stored
extra dbs have been created. They are all named db1, db2 etc. We are now at
db29.

I am not too familiar with Access and the security side effects. Can
someone explain why these DBs are being created? Should I delete them or
leave them alone? All the sizes vary.

Currently all the users have Full Permissions. I am thinking maybe we
should just unsecure the db and go back to the way it was for years prior,
but a quick search is leading me to believe that is easier said than done.

This DB is added to by approx. 10 users. It only has 15 or so tables (all
records are being recorded in just one table the rest are for drop down
fields.) They do have about a hundred different queries set up that are used
by the different users to enter appointments, view appointments, etc. by
contract, etc.

We know we aren't using this to it's full advantage, but it has gotten us
through for the last 10 years. (The current version is Access 2003.)

Thanks for any help! ~Gretchen