can't edit records with null values

  • Thread starter Thread starter djc
  • Start date Start date
D

djc

can't edit records containing null values in any of the 'bit' (yes/no)
fields from a ODBC linked table (jet). The table is from an sql 2000 server
database. I get a runtime error 3197 "the ms jet database engine stopped the
process because you and another user are attempting to change the same data
at the same time" Other fields with nulls don't produce the error. If I
manually enter data into the fields instead of the default null then I can
edit from my access app. If there are nulls however my access app produces
the above mentioned error.

This is my first time using a linked table like this (sql server). I need
help on this one. Anyone?
 
This is a common problem using Access Linked Tables FE and Sql BE

On Sql Set all of the Bit fields to NOT Allow Nulls AND set the Default
Value to Zero (0). ReLink Access FE to Sql BE and Problem solved!

Ron W
 
Back
Top