Topic: Identity issue

Am using a table in MS Access connected to SQLDBX using ODBC.

If you use Insert New Data Row, "an unique feature of SQLDBX", am not able to leave the auto inc column as auto inc.

Please advice.

Regards.


Ref:
---------------------------
SqlDbx
---------------------------
You tried to assign the Null value to a variable that is not a Variant data type.

---------------------------
OK   
---------------------------

Quote Post 1

Re: Identity issue

There's does not seem to be a way to find out if column is
autoincrement using ODBC interface.

Quote Post 2