Reserved Words

[restucci]

I am attempting to update/insert to a Microsoft Access Database. I have
a database column that is unfortunately using a the reserved word
'output'. Changing this name isn't a very viable option (at least not
now). My problem is that I cannot get the database to update using .net
because it gives me the following error: "The field
'tblTimesheetEntries.Output' cannot contain a Null value because the
Required property for this field is set to True. Enter a value in this
field." It's all bound correctly on the page and I'm pretty sure it
is a problem with using the reserved word 'output'. The column name
output is bracketed ([output]) in the update and insert statements. If
anyone knows of a workaround for this it would be greatly appreciated.

Jimmy

 

[Marina Levit [MVP]]

The message doesn't look like a reserved word issue. It looks like the
update statement being generated is trying to set this field to NULL.

 

[Guest]

Jimmy,

Using [output] is all you should need to do to use the Access reserved word
as a column name.

I think you have some other problem. I would follow the error message about
the null value.

Kerry Moorman

 

[restucci]

Thank you all very much for the responses. After I looked at the table
again i realized that there was no primary key defined. I added a
primary key and that took care of all of the problems.