Db1 ??

  • Thread starter Thread starter Pwyd
  • Start date Start date
P

Pwyd

I have a multi-user database. Access uses some kind of locking-exclusion
method for having multiple copies of the same database open at once. My
question is, what causes these "copies" named db1 2, 3 ,4 ... to pop up?
closing it improperly? and, are they safe to delete?
 
I have a multi-user database. Access uses some kind of locking-exclusion
method for having multiple copies of the same database open at once. My
question is, what causes these "copies" named db1 2, 3 ,4 ... to pop up?
closing it improperly? and, are they safe to delete?
Click to expand...

You've got a problem!

I strongly suspect that you have the database set to "Compact on Close". This
is a way to recover lost space in the database - garbage collection, so to
speak. The way Access does this is to copy the database to db1.mdb (or db2 if
that already exists, and so on); if it succeeds it will rename the new copy to
the original name of the database and delete the old copy.

For some reason your compaction is not succeeding. Check your database - or
open the most recent of the dbX databases - and see if there is a new
"CompactErrors" table. I would strongly suggest using Tools... Options to turn
OFF Compact on Close!

For a multiuser system, I would also recommend that you IMMEDIATELY split the
database using Tools... Database Utilities... Database Splitter Wizard. Each
user should have their own copy of the "frontend", containing the forms,
reports, queries, and code; and all should share (but not open) the "backend"
containing the tables.

See http://www.granite.ab.ca/access/splitapp.htm for a discussion.
 
Can be a couple of things mot likely the users have the compact on close
option set to true, set this to false (tools options -> look for the tab with
the option to disable the check).

Other option could be that user doesn't have the proper rights on the
directory where the db resides.

My guess would be the first option. Delete them? Sure what would you want to
do with them anyway? Before you take any action though be sure to make a
backup first...

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

object name doesn't follow microsoft access object naming rules 3
db1 when closing 1
I get a copy of the database called db1 when I close my database 4
compact repair fails after creating db1.mdb and deleting original mdb 2
Creates db1, db2 on "compact on close" 13
Creates db1, db2 on "compact on close" 11
Opening database won't work 3
Compacting Access database 2

Back
Top