Access Database works under WinME but not WinXP

[Charles Grammer]

We have an Access 2000 "books" database (Book titles,
Authors, etc.) that works on our Windows Me computer but
not on a newly installed Windows XP computer.

The db was adapted from an MS template (sorry we don't
remember which one) probably from Office 2000.

There are three forms in the db: Authors, Books, and
BooksSubform. The problem is that BooksSubform will not
open within the Books form on the WinXP machine. It does
open and display data on the WinMe machine.

When the subform does not open, a dialog box pops up with
the message "Microsoft Access for Windows has encountered
problem and needs to close. We are sorry ..." When the
dialog box is closed, Access closes.

The problem machine had major problems a month ago that
caused me to wipe the hard drive and do a clean Windows XP
Home install. It had been running Win98SE. I installed
Office 2000 Professional, SP-1a, SP-2, and downloaded SP-3
and all updates for Office.

I should add that the db has what I think is an unrelated
problem: a form was previously deleted, and a message pops
up when the db is opened: "The form name 'Switchboard' is
misspelled or refers to a form that doesn't exist" This
message has been popping up for a long time and seems to
be benign in that the db has been working otherwise.

Can anyone help?

Charles Grammer

 

[Allen Browne]

Charles, the error message does indicate a corruption in Access, and could
be the reason it's now failing on a different platform. Here's how you can
get Access to rebuild your database.

1. Create a new (blank) database.

2. Go to Tools | Options | General, and check all the boxes in the Name
AutoCorrect section. This is unreliable and undesirable, and contributes to
corruption.

3. Import all the objects (File | Get External | Import) from your existing
database--tables, queries, forms, ...
If "Switchboard" is listed in forms to import, do *not* import that, since
it's known to be corrupt.

4. Press Ctrl+G to open the Immediate window.
Choose Compile from the Debug menu.
Fix any errors.

 

[Dirk Goldgar]

[...]

2. Go to Tools | Options | General, and check all the boxes in the
Name AutoCorrect section. This is unreliable and undesirable, and
contributes to corruption.

Did you mean *uncheck* the boxes in the Name AutoCorrect section, Allen?
That's what I'd expect you to be saying.

 

[Allen Browne]

Whew. YES! UNcheck these boxes.

Thanks Dirk.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

[...]

2. Go to Tools | Options | General, and check all the boxes in the
Name AutoCorrect section. This is unreliable and undesirable, and
contributes to corruption.

Did you mean *uncheck* the boxes in the Name AutoCorrect section, Allen?
That's what I'd expect you to be saying.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Roger Faucher]

Consider the following:
Install MDAC 2.7 SP1 Refresh from
http://www.microsoft.com/downloads/details.aspx?
FamilyID=9ad000f2-cae7-493d-b0f3-
ae36c570ade8&displaylang=en
and
Install JET 4.0 SP6 from
http://www.microsoft.com/downloads/details.aspx?
FamilyID=5e032646-04ef-40cd-9c1a-
e3b586ae1005&DisplayLang=en

You may find references online to JET 4.0 SP7 but I
suggest you stay away from it.

HTH

Roger

 

[Charles Grammer]

Thanks for the clarification. I'll give it a try.

Charles