bigint and linked tables

B

billmt

Access 2002 displays rows in linked tables with "bigint" data types as
"Deleted". Has this problem been solved in Access 2003?
 
M

MGFoster

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.
 

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

problem when linking an Access DB to SQL Server with bigint dataty 2
Linking to bigint 1
Microsoft Access and SQL Server 4
2007 ADP doesn't recognize BIGINT data type 11
SQL Bigint convert to Access 1
Is there a way to display bigint (int64 data in MS Access? 1
Visio doesn't like bigint identity columns - is it just me? 0
Wordpress mySQL backup file ? 1

Top