Chris Gray <cpgray@library.uwaterloo.ca> writes:
> Still no luck. I tried making all fields non null and supplying a default
> value and still get the same error message.
I'm not an Access user, but I have a vague recollection that it has
problems with updating rows in tables that don't have a PRIMARY KEY
declared. There is more about this in our mailing list archives.
regards, tom lane