Access creates new database upon opening one

[tosberg]

Here's the deal:
Whenever I open MS Access2002 and select an existing database, let's call it "Payment.mdb", Access will suddenly create a Copy of it and call it "Payment1.mdb". So any changes (as I am now working with the copy)I make are made to the "Payment1.mdb" database and not the original. If I close it out and try to open "Payment.mdb" again, it will do the same thing, except this time it will call it "Payment2.mdb". This will continue to happen however many times I use it. Anyone know what's going on here?

 

[Junior1544]

is there an auto exec macro or some code that's there to do this?? is this just happening outa no where... will it do it with all databases, or just a couple, or just one...

just for kicks, i would suggest holding down the shift key while opening it... this should skip any startup options, and see if it still does it... if it does, i can't help... if it does, then i might be able to help you, because there's some code, or a macro telling it to do this...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[tosberg]

I did your suggestion and it still does it. However, I have noticed this: If I were to double-click on the "Payments.mdb" database itself it will not create a new copy. ONly when I select "Choose File..." from within Access itself does it do this. does this help? I am running Access2002(XP).