Hi
I have an error -7711 when I try to import or link tables in MS Access 2000 under XP. I can see the list of the tables which are on a RS6000 under AIX but when I try to select them I have the error. BUT the same ODBC driver works well with Excell. Someone can help me ??
thanks in advance

I don't think that's an Informix error.
Can you trace your ODBC connection with SQLIDEBUG and check the output?

I made the SQLIDEBUG and sqlprt and the result is in the attached file, at the begining it seems that there is a Msysconf table which is missing.
but I have not enough knowledge to interpret this debug thanks if you can help
Kristof

Could you check this sql?

select count(*) from informix.systables t, informix.sysfragments f where t.tabid = f.tabid and f.fragtype = 'T' and t.tabname like 'bdaclients' and t.owner like 'bmc'

Did you ask for a table called 'bdaclients'?
If so is that table in the database?
If so is the owner 'bmc'?

If you did not ask for all that, could you also trace the Excel connection and check the difference.

Yes table and owner exist and yes it is the "bdaclients" table that I try to link in access. In fact I choose it from a list that access gives me. Access find correctly all the tables that are present in the informix database, it is when i choose one and press OK that I 've got the error .
Does the problem can comes from the level release of my informix database because I think it is an old one.
thanks.

If it works in Excel an it doesn't work with Access, I think it is a microsoft thing.
ODBc is not a part of the Informix Engine, it is part of the CSDK.
You can download the latest csdk (2.80) from
http://www.informix.com/evaluate

The problem have been solved with the download of the 2.80 SDK wich contain the 3.81 ODBC driver instead of the 3.80.
Thanks a lot
Kristof