ACCESS FEED: Re: [MS_AccessPros] Linking to SQL table with bigint as PK

Kamis, 17 Juli 2014

Re: [MS_AccessPros] Linking to SQL table with bigint as PK

Doyce-

From searching online, it appears that Access 2010 and later can link to BigInt - but treat it as a String. These linked tables are updatable.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 17, 2014, at 3:38 PM, winberry.doyce@roadsysinc.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

Is there anyway to make a PK so this is updateable?

Doyce

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

Doyce-

Correct. The view will not be updatable because you have masked the Primary Key with an expression. No Primary Key = not updatable.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 17, 2014, at 3:15 PM, winberry.doyce@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello Pros,
I need to link to an SQL table where the PK is a bigint type. As I am understanding from some research, I think I need to create a view of the table and use CAST as a VarChar to convert the datatype to something Access can use. So I need help with the syntax setting up the view in SQL management studio. The field name is MAXID. Here is my guess: Cast(MaxID as varchar) as MaxID. One comment I read on this approach says the view will not be updateable. How about it Pros? What do I need to do?
Doyce

__._,_.___

Posted by: John Viescas <johnv@msn.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)