Write conflict error with ODBC link table

S

SF

Hi,

I have migrate my back end access tables to SQL Server. While editing data
(ODBC link) from form, I receive Wirte conflict error 'The record has been
changed by other user... Copying the change to the clipboard...'. The error
allow me either copy the info to clipboard or drop change. In this case, how
can I save my work to the table here?

SF
 
G

Guest

Ï "SF said:
Hi,

I have migrate my back end access tables to SQL Server. While editing data
(ODBC link) from form, I receive Wirte conflict error 'The record has been
changed by other user... Copying the change to the clipboard...'. The
error allow me either copy the info to clipboard or drop change. In this
case, how can I save my work to the table here?

SF
 
A

Albert D. Kallal

3 things to check:

1, when you link to a table, make sure it has a primary key

2, make sure all tables have a timestamp field exposed

3, check for null bits, info here:

ACC2000: Write Conflict Error When You Try to Update Records in a Linked SQL
Server Table

http://support.microsoft.com/?id=280730
 

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