开发者

How to define composite keys in MS Access?

开发者 https://www.devze.com 2023-03-12 21:46 出处:网络
I am new to MS Access. Could anybody tell me how to define a composite primary k开发者_如何学编程ey in MS Access 2007.If memory serves correctly, you can hold SHIFT while selecting the fields in the d

I am new to MS Access. Could anybody tell me how to define a composite primary k开发者_如何学编程ey in MS Access 2007.


If memory serves correctly, you can hold SHIFT while selecting the fields in the design view. Once you've selected all of the fields that are to be part of the key, press the primary key button.


Already answered, but I wanted to chime in with additional info.

After solving my related problem, holding "ctrl" + clicking multiple columns in design view and then clicking the "primary key" icon in the upper left worked great.

I was receiving an error that stated,

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship.

I wasn't sure if it was my data, or if I was doing something wrong. Sure enough it was my data - I had accidentally entered duplicate data without realizing it.

I used the following query that I skimmed off of a dbforums.com post to quickly identify the problem:

SELECT ColumnName1
     , ColumnName2
     , ColumnName3
     , ColumnName4
FROM   TableName 
GROUP
    BY ColumnName1
     , ColumnName2
     , ColumnName3
     , ColumnName4
HAVING Count(*) > 1

After adapting the SQL to my tables the query immediately pointed out the offending entry. I eliminated it, fixed the issue in my table that allowed the duplicate to be created, and was able to create my composite primary key no problem.

0

精彩评论

暂无评论...
验证码 换一张
取 消