I am presently using a ODBC link to link my Access database to an SQL server 2000. The database seems to be fine in most respects except on occassion a Write Conflict error comes up saying someone is in the tables and the record cannot be updated. You are then given the opportunity to Drop Changes or Copy to Clipboard. I know that no one is the same data...it doesnt do this all the time...even records that are filtered from the SQL server witin the same client are not all accessible for update. The first record updates the next one updates and the third one doesnt. No ryhme or reason that I can see! I found some articles on the web describing the same characteristics, but it said that there were dates not carrying the right datatype. I have checked these and see nothing wrong with them either...I guess I am confused as to why it works sometime and not all the time if it is a coding problem... Could it be a problem with the ODBC link?
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
ODBC Access 2003 to SQL 2000
I know that no one is the same data...it doesnt do this all the time...even records that are filtered from the SQL server witin the same client are not all accessible for update. The first record updates the next one updates and the third one doesnt. No ryhme or reason that I can see!
I found some articles on the web describing the same characteristics, but it said that there were dates not carrying the right datatype. I have checked these and see nothing wrong with them either...I guess I am confused as to why it works sometime and not all the time if it is a coding problem...
Could it be a problem with the ODBC link?