Access won't save design changes on a form.

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.
 
A

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top