ozgirl
asked on
ODBC - Insert On A linked Table Failed
HI
i cant understand what is wrong so please help ...
i have an access 2003 frontend that is linked through to a SQL server backend
for some reason i can not append some records to a table. (others work perfecty well)
the message i get when trying to append is:
ODBC --Insert on a linked table 'tblQuality_Audit_Items' failed
[Microsoft][ODBC SQL Server Driver][SQL_Server] Explicit value must be specified for indentity column in table 'Table1'
when IDENTITY_INSERT is set to ON. (#545)
now even if i go straight to the table in access i try to insert a record manually i get the same message. however if i try the same in SQL server i get no message
I have A Indentiy column called ControlNumber. all other fields allow nulls
any ideas?
thanks
ozgirl
i cant understand what is wrong so please help ...
i have an access 2003 frontend that is linked through to a SQL server backend
for some reason i can not append some records to a table. (others work perfecty well)
the message i get when trying to append is:
ODBC --Insert on a linked table 'tblQuality_Audit_Items' failed
[Microsoft][ODBC SQL Server Driver][SQL_Server] Explicit value must be specified for indentity column in table 'Table1'
when IDENTITY_INSERT is set to ON. (#545)
now even if i go straight to the table in access i try to insert a record manually i get the same message. however if i try the same in SQL server i get no message
I have A Indentiy column called ControlNumber. all other fields allow nulls
any ideas?
thanks
ozgirl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i have just looked at my append query and doh.....
all working well now
thanks
ozgirl