Is there a version of Access that allows you to read BIG Interger

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm linking to SQL Server where a table's key is listed as a "Big Interger"
but Access shows the table rows as "Deleted."
Is there a version of Access that can read this data ? Or is there a way in
Access 2002 I can see without exporting/importing data
 
You should be able to read it as a Long data type in Access. Only SQL Server
smallint and tinyint translate to Access integer types.

-Dorian
 
Chris said:
I'm linking to SQL Server where a table's key is listed as a "Big
Interger" but Access shows the table rows as "Deleted."
Is there a version of Access that can read this data ? Or is there a
way in Access 2002 I can see without exporting/importing data
Click to expand...

I could be wrong, but I don't think Access/Jet supports the SQL2000
bigint data type. Certainly it doesn't map directly to any of the
standard Jet data types. Maybe it works in ADPs; that wouldn't
surprise me.

If you don't need to update the linked table, you could create a view in
SQL Server that casts the bigint field to int, and then link to that
view instead. I'm not sure what would happen if the field uses the full
digit range of the bigint data type.
 
I tested, and can confirm that ...

a) There is no change in later versions, the behaviour is the same in Access
2003 as in Access 2000.

b) An ADP does work.

Re what would happen if you used a view to convert the bigint to an int but
the column included values outside the valid range for an int - I guess
you'd have to use char or varchar. There would, obviously, be potential
issues with sorting.
 
Back
Top