Can't update SQL field with Access 2000

[Guest]

I have a web site that runs off of a SQL database. I edit the web site via a
web interface and also using Access2000. It would seem that if I edit a
record via the web site, I then cannot edit that record in Access2000. It
locks up and says this record has been changed by another user since you
started editing it. Is there a way to fix this problem?

 

[Danny J. Lesandrini]

Add a timestamp field to the SQL Server table.

 

[Guest]

I am not sure how that helps the situation. Is there something I must do
beyond just putting a timestamp field in?

 

[Danny J. Lesandrini]

I should have explained further ...

If your SQL Server table has a timestamp field, then your Access
application can easily tell whether or not the data has changed, since
the timestamp is used to compare. If it doesn't have one, then Access
goes through some complex multi-column compares and if it hits a
former Memo field (Text or Ntext) then it throws up it's hands and gives
the message you reported.

Adding a timestamp field works like magic. Simply add one, name it
anything you like, and retest the app. This may not fix the problem,
but it's the simplest and least invasive thing to try.

 

[Guest]

Well, I have to say thanks. That worked. Geeez been trying to solve that
problem forever. A definite thanks again.

 

[BillD]

What is the Web Interface you are using. I have been looking for a way to
setup my database on a web-site. I have a FE Database that connects with
linked tables to a BE SQL Server Database setup on my desktop. I want to be
able to place the SQL Server database with the Tables on a web Server and be
able to access that database with the Access Front End Database.
Any help greatly appreciated.