Microsoft Access Object Library Version Problem (Form VBA Code Problem)

[Don]

We have an application that after some form, report, and VBA code
modifications now fails to work on one machine. It spews forth errors like
"the object does not support that property", to name just one. Now, I had
seen this once before and the problem was a mis-match of versions in the VBA
References (in a VBA window Tools->References), so I headed there first.
Sure enough, the offending machine had the following:

Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applications Extensibility 5.3

Whereas the 3 other machine that work have:

Visual Basic for Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applications Extensibility 5.3

The difference being the version of the Microsoft Access Object Library
(10.0 vs. 9.0).

The offending machine is running Win2000 and (I believe) Office2000. One of
the "good" machines is XP with (again pretty sure) Office XP. The other
machines are Win2000/Office 2000 (for sure!).

I checked the offending machine, and it did not show Microsoft Access 9.0
Object Library as being available, and vice versa on the other machines.

Am I on the right track in terms of thinking this is the root of my problem?

If so, how can I resolve this version problem?

Thanks!!

Don

 

[TC]

Show some lines that the errors occur on!

TC

 

[Don]

I will try to do a detailed analysis later today, but in general we have a
switchboard like form, and when you push one of the buttons you immediately
get an error. If you pick debug, it gives another error.