Who's appending 1s to my file name?

[sja13]

One of my mantras is "The only really stupid question is the one you don't ask", so I'm asking it!

If I've been working on an accdb file, when I come to "Save Database As" the database name has at least one "1" (and often a series of them) appended to it.

Where is the setting which controls this behaviour?

I've looked at "File/Options", but can't seem to see it.

Can anyone point me in the right direction?

Ta!

 

[Ranman256]

you shouldnt have any code to do this.
If you dont, then its possible the db is corrupting and trying to save itself by saving AS.

It shouldnt do either. Make plenty of backups and compact/repairs.

 

[sja13]

Tried Repair/Compact - still appending 1s to my file name!

 

[Minty]

Because you are using "Save As" you are telling access to save Another different copy of the database you have open.

By default it will add a 1 to the existing file name as it can't save another copy with the same file name as the one you have open...

 

[AccessBlaster]

Who's appending 1s to my file name?

Oh yeah, that's me! hate when that happens.:banghead:

 

[isladogs]

Because you are using "Save As" you are telling access to save Another different copy of the database you have open.

By default it will add a 1 to the existing file name as it can't save another copy with the same file name as the one you have open...

I thought that as well. However, when I tried it (using Access 2010) it doesn't append a 1 to the file name.
It will ask whether to overwrite the existing db if saving in the default folder.

However, it is the case that older versions of Access did attach a 1 at the end of db objects such as forms if you did a Save As.
Newer versions instead write 'Copy of ' at the start of the name

And of course importing an object such as a query from another db will be renamed with a 1 at the end if that object already exists

 

[sja13]

Looks like i have an antique version of Access!

Thanks to all who contributed helpful and polite replies.

My normal routine is to save frequently, and during development I always try to document what I'm doing in the file name, along with a version number, for example "GKD V31 (fixing menu form problem).accdb".

Occasionally if only minor changes have been made I just (by instinct) hit "Save As" and accept the offered name. As noted by ridders in response to Minty, I expected to get the "name in use, overwrite?" message, but didn't, hence the multiplying 1s.

Thanks again to all contributors....