AS400 iseries ODBC VBA Excel add-in

Hi I created a VBA Excel program to get data from our AS/400 It works on my pc but not my boss's. It says 'connection failed' He has Client Access installed. What would he be missing? It seems like from the connection string below that he would need Client Access Driver but isn't that automatically installed if he has Client Access. Is there an easy way to do this so there isn't a complicated setup for each user? I need you to troubleshoot and solve this problem Here is the connection string I use. 'Create query to retrieve individual records.. Set qtDetail = [login to view URL]( _ Connection:="ODBC;DRIVER={Client Access ODBC Driver (32-bit)};UID=" & getUID & ";PWD=" & getPWD & ";SYSTEM=[login to view URL];DBQ=QGPL AXXDTA;DFTPKGLIB=QGPL;LANGUAGEID=ENU;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;TRANSLATE=1;SIGNON=1;", _ Destination:=[login to view URL]("A4")) Any help much appreciated