Database name automatically renames

[don]

We have a few databases that for some reason
automatically rename each time you open them (i.e. 1st
time database.mdb, second time database1.mdb, third time
database2.mdb, etc.). We cannot determine why it is
doing this and to make matter worse it seems random.
There are times that you can open the database and it
does not do that. It works perfectly normal. We are
running Access 2002. Any help would be great.

Thanks.

 

[Perlith]

Who created the database and/or do you have any documentation for it? It
would be a good idea (if possible) to contact them and try to find out why
it is doing that. If you cannot get in contact with them, have somebody who
is familiar with macros and Visual Basic code look at the database.

Good luck,

 

[John Vinson]

We have a few databases that for some reason
automatically rename each time you open them (i.e. 1st
time database.mdb, second time database1.mdb, third time
database2.mdb, etc.). We cannot determine why it is
doing this and to make matter worse it seems random.
There are times that you can open the database and it
does not do that. It works perfectly normal. We are
running Access 2002. Any help would be great.

Thanks.

It sounds like you're CREATING a new database instead of opening it!
How are you opening the database? When you get database1.mdb, and look
on the folder using Windows Explorer, do you now have two databases?

 

[Jeff Rush]

HI Don,

Are they doing some sort of Pack or Compact and Repair on exit?

Jeff

 

[Dirk Goldgar]

We have a few databases that for some reason
automatically rename each time you open them (i.e. 1st
time database.mdb, second time database1.mdb, third time
database2.mdb, etc.). We cannot determine why it is
doing this and to make matter worse it seems random.
There are times that you can open the database and it
does not do that. It works perfectly normal. We are
running Access 2002. Any help would be great.

Do you end up with the original database plus a copy? I wonder if this
is the result of having the Compact On Close option set, but the user
doesn't have delete permissions on the folder or file. Compacting the
database involves creating a compacted copy with a name formed by adding
a number to the end of the original name, then deleting the original and
renaming the copy. So if you can't delete the original, you'll end up
with two files.