Write Conflict

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BRC - 20 Aug 2004 23:04 GMT

Newby Access-SQL Server Question:
I have an Access front end and a MS SQL Server back end.
I imported the Access tables into SQL Server.
I have an ODBC connection to the SQL database. I am able
to edit and add records in the SQL database except I am
not able to edit new records added after the import. I
get the "Write Conflict" message.
I have missed a setting somewhere.
Any suggestions to fix this would be appreciated.

BRC

Reply to this Message

Eric Butts [MSFT] - 22 Aug 2004 17:28 GMT

Hi,

Take a look at:

You may receive write conflict errors when you update records of a linked
SQL Server table in Access 2000
http://support.microsoft.com/default.aspx?scid=KB;[LN];280730

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------

| Content-Class: urn:content-classes:message
| From: "BRC" <anonymous@discussions.microsoft.com>
[quoted text clipped - 27 lines]
|
| BRC

Reply to this Message

- 23 Aug 2004 22:20 GMT

Thanks Eric,
It worked like a champ with our linked tables.
I would have never thought to look at nulls.

All the best,

BRC

>-----Original Message-----
>Hi,
[quoted text clipped - 58 lines]
>
>.

Reply to this Message