Hurrah. But I've never had that happen. Funny too that the ADO
reference was set up as A97 never had ADO as a default reference. I bet
a zillion bucks it had something to do with that ocx.
I began disambiguating (the dao.recordset, dao.database) a number of
years ago after reading an article about it by Michka on his Trigeminal
It's probably a good idea to get into the habit, though I know not
everyone does. I go (probably needlessly) overboard with it, myself;
for example, instead of dim ooga as ComboBox I write dim ooga as
I don't know. Applications with Access 2 I did involved macros and
weren't all that involved - I did an awful lot more with dBase III+ and
IV. I know you're having great difficulty adjusting to A97, but the
experienced developers here generally say it is far better a product
than 2.0. Indeed, in my first months of using A2003, I felt the same
way you do with respect to the new product, but have eventually grown
used to it.
I don't think stuff can get blown away behind the scenes though all that
easily. In your case, assuming it was this ocx installation that caused
your problem, it's a case of differing versions of Access and/or
possibly Office. One of the reasons I went to Access 2003 from A97 was
because my applications started malfunctioning on newer machines that
had elements of Office 2000 installed. Apparantly it's fairly easy to
muck up the dlls when you've later versions of Office installed on the
same machine with Access 97. Indeed, many people here will cry foul,
but I've had very inconsistent results with A97 installs on windows XP
machines, another reason for me to abandon my very much loved A97. Of
course, I don't have control over operating system set up in departments
outside of my own and in my own department where I'd have strict control
over how Access and Office is installed, I'm a lot more successful.
With the other departments, however, I run into symptoms of the "It Guys
Hating Access" (see thread with similar name).
How these failures manifest themselves is via reference screw-ups.
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto