SQL Query View - Access 2000 Data Types

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am looking for a list of MS Access 2000 Data Types that
I can use to create tables in the SQL Query view. I have
been able to use the "CHAR" data type successfully but
have been unsuccessful using the following data types in
the SQL view query to create a table:

NUMBER, DATETIME or DATE/TIME, CURRENCY, INT or INTEGER.

They have all returned errors. Can anyone show me the
correct syntax for these data types and/or a list of them
that I can use for a query in the SQL view?

Thanks!!

John
 
Hi,


Jet or MS SQL Server (dot mdb or dot adp) ?


Assuming you use JET, and that you use ADO ( I am not sure DAO accept
all the following), so that mean NOT using the query designer, but rather,
the Immediate Window, like:

CurrentProject.Connection.Execute "CREATE TABLE .... "


The following data type should be usable without problems: BIT,
BOOLEAN, LOGICAL, LOGICAL1, YESNO, BYTE, INTEGER1, COUNTER, AUTOINCREMENT,
CURRENCY, MONEY, DATETIME, DATE, TIME, SHORT, INTEGER2, SMALLINT, LONG,
INT, INTEGER, INTEGER4, SINGLE, FLOAT4, IEESINGLE, REAL, DOUBLE, FLOAT,
FLOAT8, IEEDOUBLE, NUMBER, NUMERIC, TEXT, ALPHANUMERIC, CHAR, VARCHAR,
CHARACTER, STRING, MEMO, LONGTEXT, LONGCHAR, NOTE, LONGBINARY, GENERAL,
OLEOBJECT, GUID, DECIMAL



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top