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: 119
Thanks: 55
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: 4,533
Thanks: 91
Thanked 1,237 Times in 1,210 Posts
Minty will become famous soon enough Minty will become famous soon enough
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.
__________________
A little thanks goes a long way
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

(Please use the scales on the left if we have helped!) Mark threads as Solved once you have an answer.

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: 119
Thanks: 55
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 12:35 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 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World