Unable to save changes access 2007 in Design View

We have an existing Access 2007 db. A collegue is attempting to save some changes to the startup form (just a text label is being changed). When he closes the form it keeps prompting "do you want to save changes to the design form", he clicks "yes", and the prompt disapears, but the form doesn't close. He tries to close it again and the prompt appears again. If he clicks "No" the form closes but the changes aren't saved.

Can someone please advise?

Nick3512Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You may be experiencing corruption. Make a backup, then do this:

1) Compact the databse. Click the Office button - Manage - Compact
2) Compile the app. From the VBA editor, click Debug - Compile. Fix  any errors, then Compile again.
3) Compact again
4) Build a new, blank database. Import everything to that new database.
5) Compact
6) Compile
7) Compact

If that doesn't work, you may have a corrupt object (form or report, for example). If so, when you import, you may have trouble importing that corrupt object. If so, then either (a) recreate the object from scratch or (b) import that object from a known good source. Unfortunately, sometimes you cannot easily determine which object is corrupt. In those cases, you simply must import one by one and see if that newly imported object causes troubles - if it does, it's most likely the corrupt one.

Also make sure your Office and Windows installs are fully up to date.

Also make sure that your colleague is doing this work in Exclusive mode. Generally this is turned on by default when you make changes, but you can force Exclusive mode by first opening Access, then selecting the file you wish to open, and then selecting the Exclusive option from the combo dropdown list (attached to the textbox displaying your file to open).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nick3512Author Commented:
Hi, At point 2. In the debug menu, complite is greyed out, any ideas?

Thanks.
0
Nick3512Author Commented:
Hi, anyone able to help?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If the Compile menu is disabled, then make a change to something in the file - add a line to a VBA proc, save it, then delete it - the see if the Compile option is there.

If not, then the app is compiled, and you move along to the next thing on the list.
0
Nick3512Author Commented:
Partially solved issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.