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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to bigint 1
Microsoft Access and SQL Server 4
problem when linking an Access DB to SQL Server with bigint dataty 2
2007 ADP doesn't recognize BIGINT data type 12
Is there a way to display bigint (int64 data in MS Access? 1
Queries with param 1
SQL Bigint convert to Access 1
sqlce 3.5 insert not working 6

Back
Top