Database name automatically renames

  • Thread starter Thread starter don
  • Start date Start date
D

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.
 
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,
 
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.
Click to expand...

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?
 
don said:
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.
Click to expand...

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.
 
Back
Top