Good to know Crystal. I’ll defer to your many years of experience. J
> "Does it matter?"
yes it can matter. I have seen tables display with funky characters when a unique index is not specified ... then remove link, do it again again and specify it correctly and voila! I guess it has something to do with Access being able to keep track of what is has in memory.
~ have an awesome day ~
On 2/11/2016 8:20 AM, firstname.lastname@example.org [MS_Access_Professionals] wrote:
This is not unique to Access 2013. I've had it happen to me when linking to a table that doesn't have a primary key defined. I don't know why anyone would do that but sometimes they do. If you can, have a primary key designated on the table and if you can't, then choose a combination of fields that make a record unique.
This hasn't happened for me. If you don't specify a key field and then go to the table design in Access do you see a primary key? How about a unique index?
Does your SQL table have a Primay Key defined or only a unique index?
Duane Hookom, MVP
Date: Thu, 11 Feb 2016 06:29:42 -0800
Subject: [MS_AccessPros] Linking to SQL
Why does Access (2013) make me select key fields, when linking to SQL tables, when they are already defined in SQL? Does it matter?
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (5)|