Is there a way to display bigint (int64 data in MS Access?

[Guest]

According to the MS Access Help there is "no equivalent" for bigint data in
MS Access.

I am using the SQLServer driver.
Is there a way to display these values as a result from a SQLServer database
query.

I am able to display the bitInt values using Microsoft OLE DB Provider for
SQL Server (SQLOLEDB) in Visual Studio's Database Projects.

Is there a SQLOLEDB ODBC driver that MS Access can uses to retrieve these
values?

 

[MGFoster]

According to the MS Access Help there is "no equivalent" for bigint data in
MS Access.

I am using the SQLServer driver.
Is there a way to display these values as a result from a SQLServer database
query.

I am able to display the bitInt values using Microsoft OLE DB Provider for
SQL Server (SQLOLEDB) in Visual Studio's Database Projects.

Is there a SQLOLEDB ODBC driver that MS Access can uses to retrieve these
values?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SQLOLEDB driver is the one to use to connect to SQL Server. Use ADO in
Access (a VBA module) or create an .adp (Access Data Project) file &
indicate the SQL Server you want to connect to, when prompted. If the
number is very large (>4 trillion) I'm not sure there is a display
format that will show all the numerals. You'll probably have to create
your own format.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRDcEWYechKqOuFEgEQLjpgCg7crlzv9Ngj4JlqZjWTqi/SYlC6AAniHY
DdpNgkqavM8jYohpv4S8VadC
=xV8X
-----END PGP SIGNATURE-----