"Gretchen Hembree" wrote:

> 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" wrote:

> 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" wrote:
>
> > 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