A-2000 to A-XP Problems: References??

[Dalton]

I have a database with input forms created in Access
2000. When I upgraded to Office XP, the forms will not
work anymore. I get 'no object in the control' errors
with almost any action inside of the forms.

I did not develop the DB and my VB skills are weak. I
checked all the references to make sure they are the same
from a machine running the same DB on Access 2000. All
are the same with the exception of:

MS Access 9.0 Object Library (is 10.0 on XP)
MS DAO 3.51 Object Library (is 3.6 on XP)

Is this where my problems lie or am I looking in the
wrong place??

Thanks in advance....

 

[Cameron Sutherland]

This is normally an ActiveX problem. Look in the design of
the form and see if there is a small blank square. If so
then this is your ActiveX that the PC doesn't understand.
Try deleting it and recreating it.

If you don't have an ActiveX object then it is probably
your DAO DLL that is giving you grief. If your XP machine
doesn't have DAO 3.51 (Dao350.dll I think) and you have
the new DAO 3.6 referenced you might try unreferencing the
3.6, copying the old DLL over to the new PC, register it
(regsvr32) and select it from the reference list in Access.

-Cameron Sutherland

 

[Van T. Dinh]

"... If you don't have an ActiveX object then it is
probably your DAO DLL that is giving you grief. If your XP
machine doesn't have DAO 3.51 (Dao350.dll I think) and you
have the new DAO 3.6 referenced you might try nreferencing
the 3.6, copying the old DLL over to the new PC, register
it (regsvr32) and select it from the reference list in
Access. ..."

Not recommended! AXP (and in fact A2K also) should use DAO
3.6 Library. DAO 3.51 was for Access 97.

HTH
Van T. Dinh
MVP (Access)