Kamis, 11 Februari 2016

RE: [MS_AccessPros] Linking to SQL

 

Good to know Crystal.  I’ll defer to your many years of experience.  J

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 11, 2016 10:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Linking to SQL

 



Hi Adam,

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

warm regards,
crystal

~ have an awesome day ~

On 2/11/2016 8:20 AM, winberry.doyce@roadsysinc.com [MS_Access_Professionals] wrote:

Adam,

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.

Doyce



---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Adam,
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
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
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?


Adam







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)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar