Can Access 2003 Handle SQL Servers bigint Data Type ?

[JohnBates]

hi experts,

Our database is SQL Server 2000, but we use Access 2000/2003 as the front end via link tables.

If I define a column in my SQL Server table as data type bigint, will Access be able to handle that data type ?
I know Access willl handle int but these values will be higher than int can hold.

Thanks, John

 

[dhookom]

Access will think the field is TEXT(255).

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cmmrfrds]

Did you link the table and look at the field definition. I believe a number type of Single should handle a bigint.

 

[dhookom]

Before replying above, I created a bigint in the SQL Northwinds Employee table and then linked it Access. I then opened the linked table in design view and the BigInt field showed in Access as text.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cmmrfrds]

Thank you dhookom. The bigint is 8 bytes and the single in access is only 4 bytes so that is understandable. One option is to base the link on an SQL View. In the View cast the bigint to an integer that way ODBC should map it okay.