missing msadodc.ocx

[Eric Nelson]

Access 2000 database split into FE (forms, reports,
queries) and BE (tables only), developed on Win2K with
OfficeXP. Move to WinXP with Office 2003, open same
database and Access complains that MSADODC.OCX is
missing. Simple fix is to move that file from the Win2K
machine to the new one, but...

1. Why is this file not included anymore? Am I using
something I "shouldn't" and should really migrate?
2. If so, how do I find out what it is I did that
triggered the requirement for this file.

Thanks for the help,
Eric

 

[Douglas J. Steele]

In Access 2000, open the database and go into the Code Editor. Select Tools
| References from the menu and remove the reference to the ocx. Close the
dialog, and go to the Debug menu and compile your database. If you need the
ocx, one or more errors should be generated. If you don't get any errors,
test that the database still works as you expect, and you should be good to
go.

As to how the reference got there if you don't need it, might you have been
experimenting with additional controls on the form at some point?

 

[Eric Nelson]

Wow, Doug... that was too easy. No errors from recompile
& everything *seems* to work just fine.

Thanks,
Eric

PS. Yes, I've experimented a lot along the way.

-----Original Message-----
In Access 2000, open the database and go into the Code Editor. Select Tools
| References from the menu and remove the reference to the ocx. Close the
dialog, and go to the Debug menu and compile your database. If you need the
ocx, one or more errors should be generated. If you don't get any errors,
test that the database still works as you expect, and you should be good to
go.

As to how the reference got there if you don't need it, might you have been
experimenting with additional controls on the form at

some point?