M
Mark A. Sam
Hello,
I was having a problem with a table adding records into a subtable ([Order
Entry St Materials]) in code and receiving erro 3155. This would happen
only when entering a new record into the main form. I was able to open the
subtable and enter records manually. While investigating the problem, I
found an article which suggested to tuen the Identity Column off for the
table. Not really knowing how, I looked for a method and found out how to
do it, at least I thought. I created and ran a stored procedure
CREATE PROCEDURE [dbo].[InsertOff] AS
SET IDENTITY_INSERT [Order Entry St Materials] OFF
GO
Now no records at all can be added to the table. I get an error message,
ODBC- Insert on a linked table 'Order Entry St Materials' failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Explicit value must be
specified for identiy column in table 'Order Entry St Materials' when
Identity Insert is set to ON. (#545)
I tried reversing this by setting the Indentity to on which did no good. I
also tried setting the Identity on to another table after reading that there
could on be one table with it set to On, but that didn't fix it. I need to
get this resolved becuase the company won't be able to enter and process
orders until it is.
Thank you for your help and God Bless,
Mark A. Sam
I was having a problem with a table adding records into a subtable ([Order
Entry St Materials]) in code and receiving erro 3155. This would happen
only when entering a new record into the main form. I was able to open the
subtable and enter records manually. While investigating the problem, I
found an article which suggested to tuen the Identity Column off for the
table. Not really knowing how, I looked for a method and found out how to
do it, at least I thought. I created and ran a stored procedure
CREATE PROCEDURE [dbo].[InsertOff] AS
SET IDENTITY_INSERT [Order Entry St Materials] OFF
GO
Now no records at all can be added to the table. I get an error message,
ODBC- Insert on a linked table 'Order Entry St Materials' failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Explicit value must be
specified for identiy column in table 'Order Entry St Materials' when
Identity Insert is set to ON. (#545)
I tried reversing this by setting the Indentity to on which did no good. I
also tried setting the Identity on to another table after reading that there
could on be one table with it set to On, but that didn't fix it. I need to
get this resolved becuase the company won't be able to enter and process
orders until it is.
Thank you for your help and God Bless,
Mark A. Sam