The Data Has Been Changed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to avoid receiving this information box when I attempt to
change a field in a form linked to a SQL table in which I know that no one
else has edited the record and saved the changes before I attempted to save
my changes because no one else has access to this database or SQL server.

Thanks, P
 
Petra said:
Is there a way to avoid receiving this information box when I attempt to
change a field in a form linked to a SQL table in which I know that no one
else has edited the record and saved the changes before I attempted to save
my changes because no one else has access to this database or SQL server.

Thanks, P
Click to expand...

Add a column of type "timestamp" to the SQL Server table.
 
The SQL server table has a timestamp field...how else can I avoid this
message? Thanks, P
 
Petra said:
The SQL server table has a timestamp field...how else can I avoid this
message? Thanks, P
Click to expand...

I mean a column who's datatype is "timestamp", not a column that simply
happens to hold a date and time. If that is what you already have, then
have you refreshed the link since the timestamp was added to the table?
 
Thanks, yes I've added a timestamp field and I refreshed the links...but
still the error occurs....however, I found that I can avoid this message if I
get out of the form completely between modifying the data...is there VB that
will open and close the form after each modification?

Thanks, P
 
Back
Top