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

E

Edi

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
 
P

prabha

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" <[email protected]>
| Sender: "Edi" <[email protected]>
| 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: <[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
| 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
|
| 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
|
 
E

Edi

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.
 
R

rogersterling

Edi wrote on 02/10/2004 18:05 ET
Thanks for pointing me to the article, but that was no
the case
I norrowed it down to happen only for tables that hav
trigers. I have trigger for (Insert, Update) that store
the UserID and the datetime the changes were made for eac
record
If I remove the trigger it works fine
Hi, did you find a way around this message while leaving the triggers?
 

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