bigint and linked tables

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

Guest

Access 2002 displays rows in linked tables with "bigint" data types as
"Deleted". Has this problem been solved in Access 2003?
 
billmt said:
Access 2002 displays rows in linked tables with "bigint" data types as
"Deleted". Has this problem been solved in Access 2003?
Click to expand...

Sounds like you're linking the SQL table to Access .mdb files instead of
using .adp files & ADO connections. BigInt isn't a supported data type
in Access linked tables. Therefore, use the .adp file & ADO
connections. Or, convert the SQL column's data types to Integer, which
Access "understands" as Long Integers.
 
Back
Top