Can't save changes to forms

B

bcurran

I'm using a dbase in Access 2003 that was created in an earlier version of
Access. I can't save changes to any of the forms. Based on Allen Browne's
postings on similar questions, I tried to convert the db but found it was
already in 2003 format. The odd thing was, at least once in my struggle with
this problem I've received an error that said the db needed to be converted.
Since all forms are affected I don't know whether this indicates corruption.
Here's what Allen Browne posted in a case where he thought corruption was the
problem - should I go ahead and try this? Thanks!
************************
Try this sequence:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile 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"

4. Open Access, and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are
resolved.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
G

Golfinray

You probably have a table that is not editable (should have an arrow and
asterisk at the bottom.) If your table is not editable or your query is not
editable, your forms won't be either. Sometimes tables are not editable
becasue of keys, sometimes they come from uneditable queries (like union
queries) or other problems.
 
B

bcurran

I don't think that's the problem, because the thing I'm trying to change is a
caption. I checked on the properties of the form and it has "Yes" entered in
the allow filters/edits/deletions/additions properties.

Is it possible this has something to do with user-level security set by the
person who wrote this dbase? I *think* I'm logged on as admin - at least,
that's the user name I see - but is there some way I can determine whether I
really am logged as admin? Sorry for the noob question!
 
B

bcurran

I've managed to fix the problem! I found a post on 10/17 - 18/07 here called
"Forms Not Saving" in which Johnopal said he'd fixed the same problem by
opening the form in design mode, then viewing the code, at which point he got
a new module with no code. He closed that and after that was able to make
changes in the form. He didn't know why it worked. I tried the same thing
and it worked for me too! Any idea why?
 

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