Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY 
Author Message
 Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY

I have a weird problem using Informix CLI 2.0 in combination with
MS-ACCESS 2.0 and MS-QUERY. While trying to set up an ODBC connection
a ran into a strange problem :

When I try to attach a table from the Informix stores 7 database I get
an MS-ACCESS error : "owner_tablename" is not a valid tablename (e.g.
"informix.customer" is an invalid tablename. When I try to access the
same table from MS-QUERY, I can perform selects but no updates,
inserts or deletes.

The main difference between MS-ACCESS and MS-QUERY is that MS-ACCESS
uses its Jet-Engine, MS-QUERY doesn't.

Public has insert, update, delete on all tables and views.

Informix Belgium has advised me to put a view on every table :
"create view xxxx as select * from yyyy". This allows me to attach to
all the views except the ones on the stock table and on the stores
table.

When I grant DBA to public I a can attach to all the views from
MS-ACCESS but not to the tables. I am unable to modify the views from
MS-ACCESS, modifying them from MS-QUERY works fine.

Microsoft Belgium has advised me to drop all indexes on the tables
before attaching to them. This allows me to attach to the tables from
MS-ACCESS but not to modify them.

I'm a bit puzzled here ... Can anybody shed some light on this
problem, please.

My configurations used in testing :

Informix 7.10 UC1 on SCO 3.2.4
Informix 7.12 UC1 on SCO 3.2.5 (Openserver 5).

MS-Windows 95, MS-ACCESS 2.0
MS Windows 3.11, MS 32-bit TCP/IP, MS-ACCES 2.0

All combinations of Informix engines and client OS produce the same
errors.

Please e-mail me if you know what is going wrong.

Koen



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY

2. Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS

3. connect to the MS Access database without using the ODBC driver for MS Access

4. Informix CLI drivers and MS Access 97

5. Need help with MS-ACCESS 2.0 queries using ODBC

6. Troubles with informix ODBC drivers when using ms-access

7. Accessing MS-Access 2.0 DB using ODBC

8. Installing MS Access 2.0 ODBC drivers

9. ODBC-driver for Delph1 1.0 and MS Access 2.0

10. ISAM or ODBC driver for Attaching Paradox 5 tables to MS Access 2.0

11. MS Access 2.0 ODBC driver does not support transactions

12. JDBC or ODBC Drivers for MS Access 2.0?


 
Powered by phpBB® Forum Software