Update Data of linked SQL Server table

[Guest]

I linked a table from a German version of SQL Server 2000. I can open the
table and can edit the fields, but as soon as I want to save the table I
receive a message that the current record is in use by another user. I can
only copy my changes to the clipboard, but can't save them. The record
locator shows the reguar triangle.

I use an English version of Access 2003. Default Open mode is "shared".
Default record locking is "edited record" and "open databases uses
record-level locking" is selected. I'm the only user that accesses the table.
The only other access can happen via an order form on a web site that's
programmed in ASP. Access from the web site is very seldom (0-5 a day). I can
access and edit the tables via SQL Server Enterprise Manager without a
problem.

Can anybody tell me what I'm doing wrong and how I can make the linked table
editable. Thanks.

Marcus

 

[Roger Carlson]

Do you have a field in your linked table of datatype Bit or Real?

If so, this article might solve your problem:
http://support.microsoft.com/kb/280730/EN-US/

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Hi Roger,

thanks a lot for the tip!!

I have bit fields in the table, but they had no Null values. Adding the
timestamp made the tables editable. I have ne real fields, but it seems that
the smallmoney fields cause the same problems as the real fields.

Now I just need to solve the problem with the wrongly displayed smallmoney
data.

Marcus

 

[Roger Carlson]

Great. I went through agony over this myself some years ago. Glad my
experience can help others out.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L