Complete Database Automatically Cloning Itself

T

Tracy

I am working in Access 2003. When I open a DB, it comes up with the DB name
and a 1 at the end of the DB name. When I close it and re-open it, it leaves
DB1 on my hard drive and brings up the same name but with a number 2 at the
end of the file. I have one that has 13!! How can I stop this.
 
6

'69 Camaro

Hi, Tracy.

You probably have the "Compact On Close" option set on a multiuser database.
The database tries to compact when you close it, but this fails because you
don't have exclusive access to the file, because someone else still has the
database open. If this is the case, then split the database and place the
back end (tables and relationships) on the networked file server, and a copy
of the front end (queries, forms, modules, et cetera) on the workstation of
each user. Alternatively, you could remove the "Compact On Close" option,
but that defeats the purpose.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
T

Tracy

Hi there. Sorry, haven't had a chance to reply till now. No, compact on close
is not on and the students are working on the physical hard drives on their
pc's, not on a network drive so no one else is accessing anyone elses file.
Any other suggestions?
 
6

'69 Camaro

Hi, Tracy.

db1.mdb is the default name for a new database file in a directory. If this
file already exists when a new file is to be created, then db2.mdb is used.
The number is incremented for each new database file that is created in the
directory whenever the user does not assign a different name. The fact that
a standalone computer is creating these files means that Access is being
directed to create these new files -- separately from the common cause that
the "Compact on close" option is set in a multiuser database.

That means that VBA code, or a macro, or a shortcut with appropriate
command-line arguments is being executed to create a new database file, or
the student is creating a new file from the Access GUI and choosing not to
assign a new name for the new file.

You (or someone knowledgeable in Access) will need to do some leg work to
determine why a new database file is being created -- repeatedly in most
cases. In a school environment, I'd ask the students what's going on.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
T

Tracy

Hi Gunny. I've exhausted my options here with picking others brains, both
other instructors and the help desk and no one seems to know why a database
that already has a name, i.e. My Address List.mdb would come up with My
Address List1.mdb when opened, edited and saved again. That's why I thought
I'd post it in newsgroups and check with other experts. I'll ask around again
but this seems to be a new problem for everyone.

Kindest Regards,

Tracy
 
T

Tracy

Hi again Gunny. I guess I didn't quite word my initial question properly. The
db base has been given a name, i.e. ComputerInventory but when the students
finishes working with it and closes it, it's now named ComputerInventory1 and
ComputerInventory is still on the hard drive. The next time she opens it,
edits and closed the same db, it's given the name ComputerInventory11. To
give you a few more examples, I have:

LegalServices.mdb
LegalServices11.mdb
LegalServices1.mdb
LegalServices12.mdb
LegalServices111.mdb
LegalServices2.mdb
Hilltop.mdb
Hilltop1.mdb
Hilltop11.mdb
Hilltop12.mdb

This is what I mean by the db cloning itself. I don't get this at all. I'll
check back in a couple of days to see if anyone has been able to shed some
light on this.
 
6

'69 Camaro

Hi, Tracy.

Have the Windows System Administrator give these users "Full Control"
Windows security permissions on the directory where these files are located.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Top