November 10, 2008 at 3:03 pm
I have a table in sql server2005 with a bigint type. Linked table doesn't display values in Access2007 since Access can't match bigint type. Creating a view in sql server to convert bigint to varchar type is one option. Do you have any experience working on the Access side? Thanks.
November 14, 2008 at 4:51 am
I don't know about Acc2007, but previous versions have a Long Integer data type that handle numbers from –2,147,483,648 to 2,147,483,647
If this isn't big enough, you can use Single or Double, though these will handle decimal, rather than integer values
February 14, 2009 at 7:12 am
You can create your view and CAST the bigint as numeric(18,0) and Access will understand it & also tolerate joins with Long Integers.
If you use a varchar and try to join with that, Access will probably say "data type mismatch in query expression".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply