I have Win7 Pro 64 bit and Office 2010 32 bit on my desktop machine. I have a laptop with Office 2007 and Win 7 Home Premium, 32 bit. I do NOT have Office 2010 SP1 because I heard there was some conflict between 2010 SP1 and Office 2007. I switch frequently between both (one on the desktop and one on the laptop).
I do not have this issue on the laptop ... they are both Win 7 64 bit, but the laptop has Home Premium and Office 2007 and the desktop has Office 2010 32 bit.
On to the issue:
I converted some of my Access databases to the newer accdb from mdb format. The databases work fine on both computers. BUT, if I double click on the file or a shortcut to the file on the Win 7 Pro/2010 machine, a COPY of the file is opened and named "Filename1". If I double click again on the file or a shortcut to the file, then a different copy is opened and named "Filename2" (and this is a copy of the original "Filename", NOT the first copy "Filename1".) Of course, any changes I make to the file are saved in the new file name.
AND, if I double click on a copy, Then a NEW copy is made ..."Filename1" is copied to "Filename11"
The only way to open the original of the file is to select it and choose "open with ..." and Access.
Of course, I forget to do this about half the time. :banghead:
This does not happen with mdb files, or any other files that I can find. It also doesn't happen on the Win 7/2007 machine. It happens on every accdb file on the desktop machine, whether it’s a converted file (from mdb) or a brand new accdb file.
It seems to have started in March ... and here I was ticked at my daughter for constantly creating "new" database files called Database, Database1, Database2, etc.! And she was frustrated because her changes were "never" saved ... they were, but not in the file she was clicking on.
Older daughter has a laptop with the same operating system (Win7 Pro, 64 bit) and the same version of Access 2010, 32 bit (installed from the same disk).
I copied my file over to her computer and opened from Access, by double clicking in Explorer and by double clicking a short cut and it never duplicated the file.
I did a repair of Microsoft Office on my desktop computer, using the install disk and that did not fix the problem.
If I go to the Explorer right click on the file and choose "Open With" then, when the file opens, it is NOT duplicated. Or, if I open Access first and then open the file, it is not duplicated.
So, maybe a file association problem? I changed the association to Excel ... and then back to Access, but that didn't help. I've deleted the registry key and re-associated it.
I've been using this computer and Office 2010 since last July (2012).
I discovered this problem in May and did some file checking and found copies of files created in February and forward ... I have no idea what happened in Feb or March to cause this.
I tried the solution here ... not the exact same issue, but kind of ... oh ..can't post the link yet ...well, it's over at pariswells and it didn't work anyway (search for accdbfileassoc )
But, it didn't help ...
A point in the right direction? a solution? ideas?
I’ve had the same back-up program and virus software since last July (2012) … as I said, it seems to have started at the end of Feb or beginning of March … no major upgrades or new programs that I can recall. (I installed my tax software on my laptop … Oh, and I upgraded Quicken on the desktop, but that was in May, after this began)
Ergh ... help!
Susie
Kansas
I do not have this issue on the laptop ... they are both Win 7 64 bit, but the laptop has Home Premium and Office 2007 and the desktop has Office 2010 32 bit.
On to the issue:
I converted some of my Access databases to the newer accdb from mdb format. The databases work fine on both computers. BUT, if I double click on the file or a shortcut to the file on the Win 7 Pro/2010 machine, a COPY of the file is opened and named "Filename1". If I double click again on the file or a shortcut to the file, then a different copy is opened and named "Filename2" (and this is a copy of the original "Filename", NOT the first copy "Filename1".) Of course, any changes I make to the file are saved in the new file name.
AND, if I double click on a copy, Then a NEW copy is made ..."Filename1" is copied to "Filename11"
The only way to open the original of the file is to select it and choose "open with ..." and Access.
Of course, I forget to do this about half the time. :banghead:
This does not happen with mdb files, or any other files that I can find. It also doesn't happen on the Win 7/2007 machine. It happens on every accdb file on the desktop machine, whether it’s a converted file (from mdb) or a brand new accdb file.
It seems to have started in March ... and here I was ticked at my daughter for constantly creating "new" database files called Database, Database1, Database2, etc.! And she was frustrated because her changes were "never" saved ... they were, but not in the file she was clicking on.
Older daughter has a laptop with the same operating system (Win7 Pro, 64 bit) and the same version of Access 2010, 32 bit (installed from the same disk).
I copied my file over to her computer and opened from Access, by double clicking in Explorer and by double clicking a short cut and it never duplicated the file.
I did a repair of Microsoft Office on my desktop computer, using the install disk and that did not fix the problem.
If I go to the Explorer right click on the file and choose "Open With" then, when the file opens, it is NOT duplicated. Or, if I open Access first and then open the file, it is not duplicated.
So, maybe a file association problem? I changed the association to Excel ... and then back to Access, but that didn't help. I've deleted the registry key and re-associated it.
I've been using this computer and Office 2010 since last July (2012).
I discovered this problem in May and did some file checking and found copies of files created in February and forward ... I have no idea what happened in Feb or March to cause this.
I tried the solution here ... not the exact same issue, but kind of ... oh ..can't post the link yet ...well, it's over at pariswells and it didn't work anyway (search for accdbfileassoc )
But, it didn't help ...
A point in the right direction? a solution? ideas?
I’ve had the same back-up program and virus software since last July (2012) … as I said, it seems to have started at the end of Feb or beginning of March … no major upgrades or new programs that I can recall. (I installed my tax software on my laptop … Oh, and I upgraded Quicken on the desktop, but that was in May, after this began)
Ergh ... help!
Susie
Kansas
