Hi,

using the following SQL-Command I copy very fast a lot of rows
from a INFOMIX DB (source) into a ACCESS DB (destination):

INSERT INTO tab SELECT * FROM [ODBC;DSN=DB;UID=name;PWD=test;].tab WHERE
tab_typ = 50;

After changing the IDS Server from version 7 to version 10 I allways get the
message "Types incompatible". Why?

The column-types are serial, integer and char.

Is there anyone who is able to help me?

thanks michael