Unable to change a form/ Form locked??

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

Guest

I have an Access form that has subforms. I am trying to change a button on
the main form and Access doesn't save the change. When I tried to create a
new table in the DB it gave me an error about invalid reference or some kind
of error.
Is there any idea as to why the database is locked?
I know I had exclusive access when I tried to do this.
Thank you.
 
This sounds like a corruption.

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

2. Compact the database to get rid of this stuff:
Tools | Options | Compact.

3. 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"

4. Compact again.

5. Open any code window, and check your references:
Tools | References
More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

6. See if the code compiles:
Debug | Compile

At this point, things should be working normally again. If not, follow the 6
steps for the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top