DEFAULT Clause in CREATE TABLE statement

[benasumwa]

Hi all,

How do I create a an access table programatically
though a connection with the DEFAULT clause included?

This statement fails:

CREATE TABLE MyTable (MyField1 Numeric NOT NULL DEFAULT 0)

But works with the DEFAULT removed.

I have a round 100 tables to CREATE, but in access
database. My front-end is Visual Foxpro 6.0.
The table definitions are available and the easiest
thing to do is to create them through a connection by sending SQL statements. This method works until
I include DEFAULT stuff.

Any idea?

---------------------------
Benson O. A.
Infinity Link Limited