OK, I went to the computer and installed DCOM98 separately and then reinstalled the program. It now works fine. Two questions still though:

1.) During the installation it says failed to register MSADASQL blah blah blah. I hit ok and it continues fine and the program works perfectly. Just curious why that is if you know.

2.) How come DCOM98 doesn't automatically install during installation? I had to add it to the setup files unlike MDAC that included itself. Is this a VB bug?

Thanks for any comments and thanks for helping. I had run DCOM98 on a few machines before separately and it kept saying a newer version is installed already, so I figured that it was silently installing in my program installation and never thought of installing it manually.