[AccessD] Composite Unique Key in 2010

[John W. Colby]

Way to go Susan!!!

John W. Colby

On 3/13/2015 2:52 PM, Charlotte Foust wrote:
> Susan, you nailed it.  Heaven knows why Access decided to mash the dialog
> box together like that.  That was certainly  no need, but there we are.
>
> Charlotte
>
> On Fri, Mar 13, 2015 at 11:48 AM, Charlotte Foust <charlotte.foust at gmail.com
>> wrote:
>> Susan,  that's an interesting thought.  I do have my display set to 125%.
>> I'll try setting it back to 100% and see if that changes anything.
>>
>> Thanks,
>> Charlotte
>>
>> On Fri, Mar 13, 2015 at 10:46 AM, Susan Harkins <ssharkins at gmail.com>
>> wrote:
>>
>>> Charlotte... I wish I could remember the particulars on this, but I
>>> remember a situation where properties didn't appear to be available
>>> because
>>> of the size of the dialog! Instead of shriking everything accordingly, it
>>> just didn't display the properties. Probably not your problem, but thought
>>> I'd mention it.
>>>
>>> Susan H.
>>>
>>> On Fri, Mar 13, 2015 at 1:29 PM, David McAfee <davidmcafee at gmail.com>
>>> wrote:
>>>
>>>> <Start of Natural Key VS. Surrogate Key Holy war>
>>>>
>>>>       That's because you SHOULD be using an autonumber Primary key ;P
>>>>
>>>> </Start of Natural Key VS. Surrogate Key Holy war>
>>>>
>>>> Sorry, I just had to... it's Friday :)
>>>>
>>>> On Fri, Mar 13, 2015 at 10:16 AM, Charlotte Foust <
>>>> charlotte.foust at gmail.com
>>>>> wrote:
>>>>> I'm running into a problem I've never seen before.  When I try to
>>> create
>>>> a
>>>>> unique composite key, the options to check the unique property aren't
>>>>> available.  This is on a client's machine running Windows 7 and Office
>>>>> 2010.  I've never seen this behavior before and it's making me
>>> crazy.  It
>>>>> isn't just one table either, it's all of them.  These are new tables
>>>>> created in 2010 on the machine.  It will allow me to create a
>>> composite
>>>>> Primary key, but not a composite unique key.  Has anyone run into this
>>>>> before?  I haven't in 20+ years of Access, so I'm baffled.  It's
>>>> defaulted
>>>>> to a 2007 accdb format if that makes a difference.
>>>>>
>>>>> Charlotte
>>>>> --
>>>>> AccessD mailing list
>>>>> AccessD at databaseadvisors.com
>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>> Website: http://www.databaseadvisors.com
>>>>>
>>>> --
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>