Microsoft Access can't append all the records in the append query.

Question

0.00/5 (No votes)

See more:

Hi all,

I found numerous threads online about my problem but the I'm very new to access and therefore it's hard to understand.

I'm having the following problem with my Access Database.

Microsoft Access set 0 fields to Null due to a type of conversion failure, and it didn't add 0 records to the table due to key violations, 0 records due lock violations, and 0 records due to validation rule violations. Do you want to run query anyway?

I'm using Acces 2013.And I have imported SharePoint List Data in Access 2013.

Here Following is My Query

INSERT INTO [Content Metadata Master] ([Content Name], [Metadata Name], [Value])
SELECT Content.Name as [Content Name], 'Author 1' as [Metadata Name] , [Gold Metadata].[Author 1] as Value1
FROM Content, [Gold Metadata]
WHERE ((([Gold Metadata].[Case Number])='OM-0057' And ([Gold Metadata].[Case Number])=[Content].[Name]));

Can anyone please help me explain in baby language how this problem occurs and how to resolve it without losing data.

Many Thanks,

Samadhan

Posted 11-Jun-14 3:19am

samadhan_kshirsagar

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gary Henning · Answer 1 · 2014-06-11T12:59:00

My first guess would be that [Gold Metadata].[Author 1] as Value1 should be [Gold Metadata].[Author 1] as Value since it's listed as Value in the insert statement.

Also, I'm not sure about your WHERE clause. You seem to be checking to see if the same field [Gold Metadata].[Case Number] is equal to a const value AND [Content].[Name] (is this supposed to be [Content Name]?). If you're only updating rows where the case number = 'OM-0057' then you don't need the AND statement. Maybe you're looking for an OR statement there.