To All: I just recently installed cumulative PTFs on our AS400 to update the current operating systemn. I use IBM's Client Access to migrate from my PC over to the AS400. I use Microsoft Access on a regular basis to bring down and/or link files from the AS400. Prior to the install of the PTFs on the AS400, I could import or link any file from the AS400 into Access by the simple functtion of import, file type ODBC, clicking on the AS400 library and then highlight the file. Now, after the install of the PTFS, when I go to import into Access and list in the file type window, ODBC, nothing happens. No ODBC Sources Window opens up that would usually list the data sources. I worked with IBM to confirm the following. We pinged the AS400 and it worked find. We issued a few commands to see if all paths were active and open for data transfer to and from the AS400 and they were. We started a Cllient Access ODBC trace and then I tried to import a file into Microsoft Access. IBM looked at the Trace file and saw that there was no activity after my attempt to import a file into Access. I never touched any of the current ODBC connections. The current IBM 32bit Access Iseries driver has always worked before. It's as if Access doesn't know where to go to find the ODBC Data sources, after the AS400 PTF installs. IBM is at a loss. If anyone has ever run into this problem before and has a potential solution, it would be greatly appreciated.
Regards
Gene Haines
Regards
Gene Haines