Jeff
You need to go to :

http://www.microsoft.com/data/download.htm

and download the latest version of:

MDAC 2.5 RTM

here is the link:

http://www.microsoft.com/data/download_250rtm.htm

this then needs to be installed on the client machine.

(to everyone else)
I know there are other ways to do this, and to just copy the relevant DLLS here - and I know theres a KB article that describes this somewhere in the depths of the MS kb, but I have done this a while ago, and encountered no end of problems with Office, SQL server, ODBC, and other beasts.