A to Z sort in form field closes Access 2002 with no error msg

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

Guest

I can't find anything in MS Knowledgebase. Has anyone had this happen, and
what did you do to solve it?
 
The problem could be caused by several things, such as a corrupted index,
Name AutoCorrect bugs, corrupted form, corrupted code, or an Access bug.

Try this sequence for starters:

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.

If the problem still exists, does this form happen to have a subform that is
based on a query? If so, post a reply for specific instructions dealing with
that.

We assume you have up-to-date service packs for Office XP and JET 4. If you
are not sure, check:
http://support.microsoft.com/gp/sp
http://support.microsoft.com/kb/239114
 
Back
Top