Access 2000 under Windows XP - Requery

[Brian]

My client has an Access 2000 database that worked perfectly under Windows 98 - they upgraded to Windows XP and now get an error message when a Requery is performed in a subform. This error does not occur in when I run the database on Access 2002 under Windows XP

 

[Wayne Morgan]

Two things to check.

First, go to the References window and compare the checked items and check that none are
listed as Missing. To get to the References, open a code window (Alt+F11) and go to
Tools|References.

Next, check for "patch levels". Are all computers at the same MDAC and Jet service pack
levels? Have the available Office service packs been applied?

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114&Product=acc2000

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

http://office.microsoft.com/officeu...ID=CD010225771033&CTT=4&Origin=CD010224971033

http://office.microsoft.com/officeu...ID=CD010225741033&CTT=4&Origin=CD010224911033

--
Wayne Morgan
Microsoft Access MVP

My client has an Access 2000 database that worked perfectly under Windows 98 - they

upgraded to Windows XP and now get an error message when a Requery is performed in a
subform. This error does not occur in when I run the database on Access 2002 under
Windows XP