You need to install Microsoft ActiveX Data Objects on the other machine. To find out which you have selected click Project --> References.

Create a setup for your app then run it on the other machine so all the necessary files are installed.

HTH