I'm trying to create a MS Access2000 table with columns for unicode text strings. It doesn't matter if I use nchar, nvarchar or ntext; the columns in Access are not unicode. Same with "null"; the columns are not nullable. Of course my syntax may be wrong, but I checked it with various resources, and it does not generate any errors.

"CREATE TABLE NewTable004( gpID int PRIMARY KEY, [Field Name] ntext(250), [Field Type] ntext(250), [Value] ntext(250), [Comments] ntext(250), GamePlan_ varchar)"

Is SQL the best method? This is a new app, and I figure that it may eventually use SQL Server instead of ADO. Or should I go back to using ADOX? Thanx!

--Mike