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

Tom Haley <tom@warwick.net> 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? It's indeed possible. The performance will vary depending on what you do, but for reasonably simple selects we have had good performance (with other ODBC drivers but SQL Retriever is supposed to be ok). >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? Probably. It will depend on what kind of PC you have on your desk and and as your SCO server. It may also depend on the queries. I wouldn't import as long as the linking gives you reasonable performance. >3) If I do link to the Informix SE database, can I make changes to the data in >the Informix SE database? You can, more or less like on native Access tables. Nils.Myklebust@ccmail.telemax.no NM Data AS, Postbox 9090, Gronland, N-0133 Oslo, Norway My opinions are those of my company