Database buggy after upgrade to XP

  • Thread starter Thread starter Applebaum
  • Start date Start date
A

Applebaum

Hello,

Ever since upgrading our office to XP (SP3), lots of little forms and
functions are not working in my database. I get the feeling that this is
due to missing DLLs or references. How can I determine if 1) I have all the
references/DLLs that I need, and 2) If I don't have what I need, how can I
tell what I need and where can I get it?

It compiles without error, but crashes frequently.

Even this doesn't work:

Me!Combo14.SetFocus

Help please!!

Thanks in advance!

Matthew
 
Hi Matthew.

There are several possible issues here. Try these steps, in order:

1. Unchcek the Name AutoCorrect boxes under:
Tools | Options | General
Explanation:
http://members.iinet.net.au/~allenbrowne/bug-02.html

2. Compact the database:
Tools | Database Utilities | 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 a code window, and choose References from the Tools menu. Look for
anything marked "MISSING". Uncheck any references you do not need. More info
on the references and the file locations:
http://members.iinet.net.au/~allenbrowne/ser-38.html

6. Still in the code window, check that it still compiles after removing
spurious references:
Debug | Compile.

7. Open any form that has a subform. If you don't already have one, put a
text box in the subform for the foreign key field (the one named in the
LinkChildFields property of the subform control). You can set the Visible
property to No, but here is a bug in Access 2002 and 2003 where it can crash
(shut down by Windows) if LinkChildFields refers to an AccessField, and you
can work around the bug by giving it a text box control instead.

8. If it still crashes at this stage, follow the steps for the first symptom
in this article to get Access to rebuild the database for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Thank you so much for this. I have done/tried steps 1-6, though probably
not in the precise order listed, I shall redo them. Number 7 sounds very
interesting, as do the tips in number 8.

Am part time on this project, so it'll be a couple of days until I can
report back.

Again, thank you very much!

Matthew
 
Back
Top