[AccessD] Composite Unique Key in 2010

Charlotte Foust charlotte.foust at gmail.com
Fri Mar 13 13:52:49 CDT 2015


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
>>
>
>


More information about the AccessD mailing list