Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-27-2017, 11:48 PM   #1
masoud_sedighy
Newly Registered User
 
Join Date: Dec 2011
Posts: 122
Thanks: 57
Thanked 1 Time in 1 Post
masoud_sedighy is on a distinguished road
record is deleted in the append query,error 2950

in my macro there are several append queries, now when i run the macro i got error "record is deleted, error 2950" on one of append query.

before migration tables to sql server i was running this macro without problem , now after migration tables to sql server i got error "record is deleted" i do not know this problem comes from where.

masoud_sedighy is offline   Reply With Quote
Old 09-28-2017, 12:28 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,614
Thanks: 136
Thanked 1,516 Times in 1,488 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: record is deleted in the append query,error 2950

This may well be something to do with the issues described here in your other thread. https://www.access-programmers.co.uk...d.php?t=296061
Error 2950 is pretty ambiguous, and come up for a variety of often unrelated reasons.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
masoud_sedighy (09-28-2017)
Old 09-28-2017, 02:06 AM   #3
masoud_sedighy
Newly Registered User
 
Join Date: Dec 2011
Posts: 122
Thanks: 57
Thanked 1 Time in 1 Post
masoud_sedighy is on a distinguished road
Re: record is deleted in the append query,error 2950

Thanks, I had not used filter(Not IN SELECT...) for append query, now is ok.

masoud_sedighy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Runtime error 3167 - record is deleted JamesN Modules & VBA 2 10-27-2016 06:00 AM
"Record is deleted" error with query dgreene Queries 3 08-17-2012 10:37 AM
Record Deleted when using append query poohgc Queries 0 05-13-2009 08:52 AM
Record is deleted error message Uncle Gizmo General 1 08-03-2006 01:35 PM
Error #3167 Record Deleted PlasticsGuy Modules & VBA 0 02-03-2005 06:38 AM




All times are GMT -8. The time now is 08:50 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World