Error:"Another user or application has deleted this record or changed the value"

Edi

unread,

Feb 9, 2004, 5:23:16 PM2/9/04

to

In Access 2000, I have a project based on SQL Server 2000.
I double click on a table to open it.
I select a record and press the Delete key I get the
following error message:
"Another user or application has deleted this record or
changed the value its primary key"

I press OK and the record IS deleted.
Also, I made sure that I am the only one in the database
and no other user or application is accessing it.

Any one knows this problem or has run into it?

Thanks
Edi

prabha

unread,

Feb 9, 2004, 8:12:28 PM2/9/04

to

Hi Edi,

Any chance you are running into issue noted in:
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."

--------------------
| Content-Class: urn:content-classes:message
| From: "Edi" <anon...@discussions.microsoft.com>
| Sender: "Edi" <anon...@discussions.microsoft.com>
| Subject: Error:"Another user or application has deleted this record or
changed the value"
| Date: Mon, 9 Feb 2004 14:23:16 -0800
| Lines: 15
| Message-ID: <d9c001c3ef5b$500f7ac0$a601...@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPvW1AP/zCbrjFxQBmGs5ApTuouQw==
| Newsgroups: microsoft.public.access.adp.sqlserver
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.adp.sqlserver:16349
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver

Edi

unread,

Feb 10, 2004, 6:05:11 PM2/10/04

to

Thanks for pointing me to the article, but that was not
the case.
I norrowed it down to happen only for tables that have
trigers. I have trigger for (Insert, Update) that stores
the UserID and the datetime the changes were made for each
record.
If I remove the trigger it works fine.

>.
>

rogersterling

unread,

Aug 28, 2012, 1:09:42 PM8/28/12

to

Edi wrote on 02/10/2004 18:05 ET :
> Thanks for pointing me to the article, but that was not
> the case.
> I norrowed it down to happen only for tables that have
> trigers. I have trigger for (Insert, Update) that stores
> the UserID and the datetime the changes were made for each
> record.
> If I remove the trigger it works fine.
>

>> | Content-Class: urn:content-classes:message
>> | From: "Edi"

>> | Sender: "Edi"

>> | Subject: Error:"Another user or application has deleted
>>
>>
> this record or
>> changed the value"
>> | Date: Mon, 9 Feb 2004 14:23:16 -0800
>> | Lines: 15
>> | Message-ID: <d9c001c3ef5b$500f7ac0$

>> | Thread-Index: AcPvW1AP/zCbrjFxQBmGs5ApTuouQw=>| Newsgroups:

Hi, did you find a way around this message while leaving the triggers?