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?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor 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
 
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 )Connect With a Mentor 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
All Courses

From novice to tech pro — start learning today.