Problem

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

Guest

I have Access 2003. I have been doing some updating to my database, and all
of the sudden, when I go from the edit mode back to normal mode, the database
won't stop recaluclating. At the bottom left corner, it continues to say
"Calculating..."

When I get all the way out of Access and then back in, it is fine again.
Does it every time. I have compacted, but it doesn't help.

Also, when I am in certain forms in the edit mode, the name of the form at
the very top of the screen flickers a little bit, the way an old florescent
sign flickers.

What could be wrong?

Brossyg
 
Could be several factors here.

1. Conditional formatting
If you use conditional formatting on any of the text boxes in this form -
particularly if a calculated control is conditionally format - you could try
temporarily removing the formatting to see it that is the issue. If this is
the cause, you may find that applying Service Pack 1 for Office 2003 helps.
More information on the issue:
http://members.iinet.net.au/~allenbrowne/bug-05.html


2. Name AutoCorrect
Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilities | Compact
More information:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Editing in break mode
From your description, it sounds like you may be editing the module (code)
while the form is running (i.e. without switching the form to Design view).
Without proof, I believe this occassionally corruptes the form's module as
Access gets confused between the 4 copies of the code it is trying to manage
(the canonical and compiled versions of the original and the temporary
form).

To remove the corruption, 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"
Then compact, and compile again. Then avoid editing in break mode for a
couple of weeks, and see if - combined with #2 above - the problem ceases.

Other suggestions on avoiding corruption:
http://members.iinet.net.au/~allenbrowne/ser-25.html

4. Flicker
If this form contains a tab control or option groups and you are running on
Windows XP with themes turned on (the default), see:
http://members.iinet.net.au/~allenbrowne/ser-46.html
 
Back
Top