Form give error on edits.

  • Thread starter Thread starter Greg Wilson
  • Start date Start date
G

Greg Wilson

I have an Access XP (SP2) form that uses a linked table
(SQL2K) to store data. The form works fine to record
data, but whenever any user tries to edit a record, they
recieve the "This record has been changed by another user
since you started editing it. If you save the record,
you will overwrite the changes the other user made."
error message. The "Save Record" button is greyed out.
The form allows new records to be created without issue.

This message appears every time we try to edit a record,
even when only one user is using the DB.

What is going on?
 
--------------------
| Content-Class: urn:content-classes:message
| From: "Greg Wilson" <[email protected]>
| Sender: "Greg Wilson" <[email protected]>
| Subject: Form give error on edits.
| Date: Wed, 14 Jan 2004 08:34:39 -0800
| Lines: 13
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcPavE5U8CYJ7WqlQimyeKA/5+CQjw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.forms
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.forms:250698
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.forms
|
| I have an Access XP (SP2) form that uses a linked table
| (SQL2K) to store data. The form works fine to record
| data, but whenever any user tries to edit a record, they
| recieve the "This record has been changed by another user
| since you started editing it. If you save the record,
| you will overwrite the changes the other user made."
| error message. The "Save Record" button is greyed out.
| The form allows new records to be created without issue.
|
| This message appears every time we try to edit a record,
| even when only one user is using the DB.
|
| What is going on?
|

Have you seen:
ACC2000: Write Conflict Error When You Try to Update Records in a Linked
SQL Server Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;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

"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."
 
Back
Top