Re[2]: INFORMIX tables into ACCESS?
I am just now playing with this using access 97. It was really simple to link to an existing informix database and pull in the definitions and also as easy to export a new table to Informix from Access. I have not looked in detail at the changes in data types that may exist as well as the fact that you loose your integrity rules but I was amazed at how simple it was to look at and modify the data. I do have one problem that I would like to ask about though. When opening a Access database that has linked informix tables after their initial migration I am getting and ODBC error? I do not get prompted for a userid or password, which I did when I set up the intial link, and wonder if this may be related to the problem? Any insights would be most appreciated.. Tony Barker -- State of Indiana - DBA ____________________Reply Separator____________________ Subject: Re: INFORMIX tables into ACCESS? Author: "Patric Stephan" <past0001@stud.uni-sb.de> Date: 12/23/97 8:50 AM -monk--- <monk@halcyon.com> schrieb im Beitrag <67mrvp$g0u$1@brokaw.wa.com>... > Hi there, > Anyone know if it's possible to open up Informix tables with MS Access in a > Win95 environment? Yes! We use on an RS6000 Host INFORMIX-ONLINE 5 with INFORMIX-STAR and on the Windows 95/NT Clients INFORMIX-CLI. In INFORMIX-CLI there is an ODBC-Driver that allows you to use MS-Query. And with MS-Query, you can include the tables to MS Access. For installation routines post again. A second possibility (a cheaper one, that work very fine with HP/UX and Informix but is not so easy to install with AIX) is the program TUN. This is an Software form ESKER, that include terminal emulations, NFS, and ODBC-Driver for HOST and Client for different databases. Live long and prosper! Patric >Received: from mailhub.isd.state.in.us (10.1.23.15) by ima.isd.state.in.us with >SMTP > (IMA Internet Exchange 2.1 Enterprise) id 00153624; Tue, 23 Dec 97 07:15:51 >-0500 >Received: from fire.isd.state.in.us (firewall-user@fire.isd.state.in.us >[10.1.1.2]) > by mailhub.isd.state.in.us (8.8.4/8.8.4) with ESMTP > id HAA12481 for <tbarker@isd.state.in.us>; Tue, 23 Dec 1997 07:13:39 -0500 >(EST) >Received: by fire.isd.state.in.us; id HAA19800; Tue, 23 Dec 1997 07:13:38 -0500 >(EST) >Received: from rmy.rmy.emory.edu(170.140.97.4) by fire.isd.state.in.us via smap >(4.0) > id xma019743; Tue, 23 Dec 97 07:13:15 -0500 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id EAA01631 >for informix-list-out; Tue, 23 Dec 1997 04:55:01 -0500 (EST) >From: "Patric Stephan" <past0001@stud.uni-sb.de> >Message-Id: <01bd0f7f$dd49b3a0$05c8c8c8@pat1> >Subject: Re: INFORMIX tables into ACCESS? >Date: 23 Dec 1997 08:50:59 GMT >Reply-To: "Patric Stephan" <past0001@stud.uni-sb.de> >Organization: University of Saarland, Computing Center, Germany. >Sender: informix-list-owner@rmy.emory.edu >To: informix-list@rmy.emory.edu >X-Informix-List-Id: <news.46906>