Database is copying itself

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several mdb files that contain links to the central table. The mdb
files are located on tables in specific directoryies for each work group on
our Network.

The problem is that when someone opens the forms, the mdb file that contains
it creates a copy of itself, numbered db1, db2, db3...etc. This makes it
difficult for users to decide which form to use. I am at beginner to
intermediate level in Access, someone please help.
 
Hi.

It sounds like you have multiple users sharing the same front end database
files across the network and when each user closes his database front end,
the automatic "compact on close" is attempting to compact the database file.
It doesn't complete the compaction because other users are still using the
same database file on the network. Therefore, you'll see a db1.mdb and
sequencial numbers for every time this happens.

You have two options to fix this. You can give each user his very own copy
of the front end of the database for his workstation, or you can turn off
the "compact on close" setting.

If each user has a copy of the front end database on his workstation, the
"compact on close" would not affect anyone else's usage of the database,
because they would all have their own copy of the front end on their own
workstations. Also, this would greatly reduce the chances of corruption.

For more information on split databases for multiple users on a network and
compacting databases, see the following tips on the same Web page:

http://www.access.qbuilt.com/html/gem_tips.html#SplitDB

http://www.access.qbuilt.com/html/gem_tips.html#Compacting

HTH.

Gunny

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

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
Back
Top