This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: Wanted: Lotus Domino Middleware Solution on AS/400 ~Fred Chuveluplopakoi 24.Jul.03 05:42 PM a Web browser Applications Development 6.0.2 CF1iSeries
You cannot access a Microsoft Access database directly from an AS/400. Microsoft Access is a file-based database rather than a server and as such provides no hooks that an AS/400 could use. You could upgrade your Access database to MSDE (Microsoft Database Engine), which is a stripped down version of SQL Server, and then connect to that from an AS/400. MSDE is included on any edition of the MS Office 2000 CD in the \SQL\x86\setup directory.
Be extremely careful if you use LS:DO. It generates inconsistent resultsets and should not be used for anything remotely mission critical. LC LSX is the preferred data access methodology, but I have found it to be poorly documented and the examples difficult to follow.