Weird table question

[Guest]

I added two fields to my linked (sql) table. when I try and add data to the
fields it says "the record has been changed by another user.........

So I tried to endter directly into the table and it says the same thing.
This data I am entering is into a fied that already has data in the columns.
However when I add data into a new record it will accept it. Why is this? It
is going directly into the table for my test and it wont accept it?

 

[Jeff Boyce]

I ran into a similar situation. The solution involved adding a field of
type Timestamp in the SQL-Server backend table. Apparently SQL and Access
use this to check/confirm that the record hasn't been touched by someone
else. As it happened in my situation, there was a Yes/No (bit) field in the
table, and some suggestions in the newsgroups that that field type in a
table ends up requiring the Timestamp field (I didn't ask!)...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

OK Jeff I will give it a shot and let you know.

Thanks again

 

[Guest]

Jeff,

I gave it a try (added a date field) and receive the same error? Additional
ideas are welcome. Thanks again

 

[Guest]

Jeff,

I may have done it wrong afte rre reading it. Do I add acolunm named
Timestamp? If so what is the daatatype? Is that datetime?

Thanks again

 

[Guest]

IT WORKED THANKS AGAIN. WOW I WOULD HAVE NEVER FIGURED THAT OUT!