Re: Using MS Access 7 as Query Tool with Informix SE?

Tom Haley wrote: > > I've been trying to come up with a simple way to query an Informix SE 4.1 > database engine on an SCO UNIX server (r3.2v4.2) using tools on a Windows 95 > client PC. So far, my research has come up with using MS Access 7.0 in > conjunction with SQL Retriever (which uses ODBC). Cost is an issue, and I > already have Access. My questions are: > > 1) Am I way off base or is this possible, and if it is, what kind of > performance can I expect? > Depending on the client PC, query, other things happening on the network and server, etc..... you should be able to have find to good performance. I have been running Access against 7.1 and am pleased. > > 2) If I'm just using Access as a query tool, can I assume that importing the > tables of the Informix SE database is better then linking to the database? > Only if the data is VERY static. Otherwise any performance gains (btw I am assuming a p90, or greater, w/ 16+mb of memory) will be offset by the time needed to import the data. > > 3) If I do link to the Informix SE database, can I make changes to the data in > the Informix SE database? > The tables will need to have a unique index or primary key defined in order for Access to be able to update them. > > Any opinions would be greatly appreciated. > > Tom > All in all I would go for it. IMHO Access has a high coolness factor for querying/reporting and data manapulation/conversion. Hope this helps.