I was sent a database to repurpose for a new project. I last used Access in about 2009...
So far, I've got through ok, albeit slowly in places.
I added my tables & forms into the old database, so I could copy the formatting etc. I used a different naming convention so they're all separate (original was "mainForm" mine is "FrmMain" etc).
I was literally just putting the fininshing touches on everything when I wanted to set the default opening form to mine not the original. I looked up & followed MS instructions about File>Options>Current database & set the form to mine.
However, I've found that my FrmMain has been overwritten with the original MainForm content whilst retaining the FrmMain name. No problem, I have a backup copy form. Nope overwritten.
OK, I'll open the backup copy DB. Overwritten - this is some application-level thing?
Please could someone tell me how to stop it overwriting my form then how to set my form as the correct one?
There was always a tight deadline on this and my client is needs this out in the field tomorrow, I am completely screwed.
Many thanks
UPDATE I went back into the options settings and changed it back to the original "MainForm" & lo & behold, my form is back. However, I need to be able to set it so my form opens - how do I do that please? I can find nothing online about this.
UPDATE. This is mad - it's changed everything again and I currrently can't get it to change back.
So far, I've got through ok, albeit slowly in places.
I added my tables & forms into the old database, so I could copy the formatting etc. I used a different naming convention so they're all separate (original was "mainForm" mine is "FrmMain" etc).
I was literally just putting the fininshing touches on everything when I wanted to set the default opening form to mine not the original. I looked up & followed MS instructions about File>Options>Current database & set the form to mine.
However, I've found that my FrmMain has been overwritten with the original MainForm content whilst retaining the FrmMain name. No problem, I have a backup copy form. Nope overwritten.
OK, I'll open the backup copy DB. Overwritten - this is some application-level thing?
Please could someone tell me how to stop it overwriting my form then how to set my form as the correct one?
There was always a tight deadline on this and my client is needs this out in the field tomorrow, I am completely screwed.
Many thanks
UPDATE I went back into the options settings and changed it back to the original "MainForm" & lo & behold, my form is back. However, I need to be able to set it so my form opens - how do I do that please? I can find nothing online about this.
UPDATE. This is mad - it's changed everything again and I currrently can't get it to change back.
Last edited: