Access won't save design changes on a form.

[Jeannie S]

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.

 

['69 Camaro]

Hi, Jeannie.

Make sure that you have opened the database exclusively before making design
changes.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Allen Browne]

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

 

[Jeannie S]

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.