September 30, 2005 at 11:47 am
I have a table in SQL2k/sp2 database with PK using bigint datatype. When I link this table to MSAccess2k database am getting #deleted instead of data. Before when datatype of this column was int there wasn't any problem to get the data. Problem started when I changed datatype to bigint.
Any ideas?
Thanks,
Markus
September 30, 2005 at 11:59 am
Probably because Access can't deal with numeric values that big. Access has an integer and long integer data types, but these correspond to SQL Server's small integer and integer data types. In other words Access can only handle up to 4 byte integers, but big int is 8 bytes.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 30, 2005 at 12:36 pm
Access understands bigint in SQL as Text datatype. Why it can't hadle it as text datatype?
September 30, 2005 at 1:56 pm
Access doesn't implicitly convert the bigint to a text column so it blows up. If you create a view that casts the bigint to a varchar and define a linked table to the view, it works.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 30, 2005 at 2:07 pm
Thank you so much, it works.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply