Missing SQL Server 2005?

Question

I am trying to set the column as a 64 bit integer, but my available options are tinyint, smallint and int. Where did bigint end?

Notes. I am using Access 2008 to access my SQL Server.

Answer 1

The problem is not in SQL Server. In SQL Server 2005, you can declare a column as bigint as follows:

Create Table Table( Col1 bigint )

The problem is that MS Access does not recognize it bigintas a data type.

, ADO. help article Microsoft, , Access - bigint (. " Access" Access).

Answer 2

Access 2007 bigint, .

, CURRENCY (MONEY SQL Server) 10000 .

myCurrency = myBigInt / 10000

myBigInt = myCurrency * 10000

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

Answer 3

Access ODBC. bigint.

And here's an article called Handling SQL Server bigint data type in Access 2007 using ADO , which offers two approaches to handling this: convert bigints to varchars or options . Of course, this makes you nauseous, but they sound like they can handle your problem.