Key SQL Keywords not recognized???????

[RLK]

I can't get Access 2000 to recognize keywords such as
DEFAULT and IDENTITY. Get syntax error when I use them.
Even code copy/pasted from the Knowledge base does not
work. Any ideas on what I'm missing anyone?

 

[Douglas J. Steele]

How are you trying to use them? You'll have to show us code samples: we're
not prescient!

 

[Guest]

Even the most simple of statements will not work. If I
enter the following in the MS Access 2000 SQL Query View
Window:

Create Table TestTable (Field1 Int Default 0)

This should created a test table with one field and set
it's default value to 0. Instead, I get a "Syntax error
in CREATE TABLE statement" error and the
keyword 'DEFAULT' get's highlighted. I can copy and
paste the same statement into the SQL Server Query
Analyzer and it will work with no problem. The same
thing happens when I try to use the IDENTITY keyword or
define a field as type DECIMAL. It's almost as if the
version of Access 2000 that I have does not support it.

 

[Van T. Dinh]

The DEFAULT statement can only be executed through the JET OLE DB provide
and ADO, NOT through DAO or the Access interface.