asked on Can't update MS SQL2005 table from MS Access form
I'm trying to update a field in an MS SQL 2005 table from a form in MS Access. I keep getting a Write Conflict but I'm the only one using the db. I get the same error even if I try to update a record in the table without going through the form. I'm the db admin for the database. I can append with no problem. The table has a primary key. Any ideas?
Microsoft AccessMicrosoft SQL Server
Last Comment
WhamMcC
If you have bit fields in your table try setting allow nulls to false
ASKER
You may be onto something but when I attempt to change the data type not allow nulls, I get the following error message:
'Rebates' table
- Unable to modify table.
Cannot insert the value NULL into column 'Prep01', table 'dbSalesInfo.dbo.Tmp_Rebat
The statement has been terminated.
Is this because I have nulls and if so how can I get rid of them?
'Rebates' table
- Unable to modify table.
Cannot insert the value NULL into column 'Prep01', table 'dbSalesInfo.dbo.Tmp_Rebat
The statement has been terminated.
Is this because I have nulls and if so how can I get rid of them?
Can you initialize the values to spaces if char or 0 if numeric?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!