Access creates a second database

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

When I open my Access database named "Tempo.mdb" a second
database is created named Tempo1.mdb and that becomes the
working copy. If I close Tempo1 and reopen Tempo a third
DB is created called Tempo11.mdb and that becomes the
working copy.

Any insight as to why this is happening and how to turn it
off?
 
When I open my Access database named "Tempo.mdb" a second
database is created named Tempo1.mdb and that becomes the
working copy. If I close Tempo1 and reopen Tempo a third
DB is created called Tempo11.mdb and that becomes the
working copy.

Any insight as to why this is happening and how to turn it
off?
Click to expand...

Do you have the database set to "Compact on Close"? It may be
attempting to compact the database and failing. This is *NOT* normal
behavior!
 
Yes it is set to compact on close, but the second database
is "spawned" on opening.
Click to expand...

Even if you hold shift down to prevent startup code and macros from
running? The only thing that is ordinarily "spawned" at startup is the LDB
file, but that should also automatically be deleted when you close.
 
Yes it is set to compact on close, but the second database
is "spawned" on opening.
Click to expand...

Do you have a Startup macro or a startup form? What if any code is
getting executed? Do you in fact have read/write/create/delete
privileges on the folder containing the database?
 
Back
Top