Access won't save design changes on a form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am an experienced Access user. I am on Office XP, Office 2003. Access
won't let me save design changes on certain forms. HELP! I am stumped.

Thanks.
 
As well as exclusive access to the database, try these ideas:

1. Close the database, and check in the same folder for a small ldb file
with the same name. After a crash, this may contain spurious locking
information, and prevent you from changing the forms. Delete the file.
Restart Access.

2. If the database is secured (mdw), do you have permissions?

3. Uncheck the Name AutoCorrect boxes under:
Tools | Options | General
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

4. Compact the database to get completely rid of the name auto-corrupt
stuff:
Tools | Database Tools | Compact

5. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

6. Compact again.

7. If you are still stuck at this point, get Access to rebuild the database
for you by following the 6 steps for the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Thanks for the responses...the suggestions didn't fix the problem.
What I did do was to redo the form, the problem is not on the re-do but
remains on the orig. I intended to get rid of the orig. One interesting
thing...if I try to rename the original form, I get this message "The
operation on the | object failed. The OLE server may not be registered. To
register the OLE server, reinstall it."
I worked around the problem. Thanks for your help.
 
Back
Top