Microsoft Access无法附加追加查询中的所有记录。 [英] Microsoft Access can't append all the records in the append query.

问题描述

大家好，



我在网上找到了很多关于我的问题的帖子，但是我很新，因此很难理解。



我的Access数据库遇到以下问题。



由于转换失败的类型，Microsoft Access将0字段设置为Null，并且由于密钥违规而没有向表中添加0条记录，0条记录到期锁定违规，以及由于验证规则违规而导致的0条记录。你想要运行查询吗？



我正在使用Acces 2013.And我在Access 2013中导入了SharePoint列表数据。





以下是我的查询



INSERT INTO [内容元数据大师]（[内容名称]，[元数据名称]，[值]）

SELECT Content.Name为[内容名称]，'作者1'为[元数据名称]，[金元数据]。[作者1]为价值1

来自内容，[黄金元数据]

WHERE（（（[黄金元数据]。[案例编号]）='OM-0057'和（[黄金元数据] 。[案件编号]）= [内容]。[姓名]））;





有谁能帮助我用婴儿语言解释这个问题是如何发生以及如何在不丢失数据的情况下解决它。



非常感谢，



Samadhan

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

推荐答案

我的第一个猜测是[Gold Metadata]。[作者1]因为Value1应该是[Gold Metadata]。[作者1]作为价值因为它被列为insert语句中的值。



另外，我不确定你的WHERE子句。您似乎正在检查相同的字段[Gold Metadata]。[Case Number]是否等于const值AND [Content]。[Name]（这应该是[Content Name]？）。如果您只更新案例编号='OM-0057'的行，那么您不需要AND语句。也许你正在那里寻找OR声明。

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.

这篇关于Microsoft Access无法附加追加查询中的所有记录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！