Re: MsAccess -> Openlink -> Informix ( form problem )

Hi Jeff, You are more than likely dealing with a security problem. Is your ODBC username a valid Informix user ID with SELECT priviledges on the tables that you would like to view from within MS ACCESS ? Please also ensure the OPSYSLOGIN feature within the OpenLink Database Agent Configuration Section (in the Session Rule Book (oplrqb.ini) ) is enabled, this enables host level user verification and ID assigment as opposed to all users being mapped to the user ID of the account that initiailizes the OpenLink Request Broker (oplrqb), which in this might not have SELECT priviledges on the tables that are being blanked in Form or Datasheet view.. Please let me know how you get on. Jeff So <jcs@ExternalServer.travelsurf.com> wrote in article <4tanjv$ls2@cssun.mathcs.emory.edu>... > I have successfully installed the Openlink ODBC driver and connect MSACCESS > between my window NT machine and the Informix 7.1 on Solaris. However, the > problem occurs when I try to generate forms under Access. Among 20 tables > in the informix database, I can only generate the entry form for about half > of them, the others only give me a blank page. I use design option to check > the > forms, all the field are there. It seens that they are just invisible. > Does anyone know what the problem might be? > > I joint this mail-list recently, if this is not the kind of question people > expect here, please let me know and also kindly tell me which mailing list > shall I post this kind of question. Thanks. > ------------------------------------------------------------------ > Jeff C. So e-mail: jcs@travelsurf.com > Internet Developer > Intersoft Systems | Tel : (403) 5430078 > #555, 333, 11th Ave S.W, Calgary, AB, Canada | Fax : (403) 2337266 > ------------------------------------------------------------------ > >