timestamp error

T

tonyak

I was receiving a Write Conflict error that was not allowing me to save my
data. So I added a timestamp field to the database.

date_in timestamp null

I have a unique index on the table. When I try and save the data from my
Access Form, I am receiving the following error:

Cannot insert a non-null value into a timestamp column. Use insert with a
column list or with a default of Null for the timestamp column.

I have tried setting the default of this control to Null, Time(), Date(),
nothing is working.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top