Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-23 : 10:37:10
|
Soeren writes "Hi There
I am playing around with some automated generation of access databases in ASP, but have
run into a problem with the "CREATE TABLE" command.
How do I set the "Allow Null" = yes for an access database via
the Microsoft
Jet database engine
or can it be done at all.
I have tried the "normal" e.g..
CREATE TABLE UserInfo (ID COUNTER CONSTRAINT MyFieldConstraint
PRIMARY KEY,
firstname VARCHAR(50)Null,
middlename VARCHAR(5)Null,
address VARCHAR(50))
It executes fine and the table is created but all "Allow zero length" are still set to No.
What am I doing wrong?
Regards,
Soeren" |
|
|
|
|
|
Allow Null problem with the Microsoft Jet database engine