Urgent Question on Access RunSQL Create Table Query and Required

[Dr. Know]

Hi,
I have searched the SQL for Access info I have, but have not been able
to come up with an answer to this problem.

Using VBA and a RunSQL CREATE TABLE command, how do you create a table
that allows certain text fields to be Zero Length.

This is different from NULL.
I can get the Allow NULLs on and off, but not the Zero Length.

This is causing major headaches with subsequent updates from an
externally linked table with some zero length text fields.

Thanks,


Dr. Know

 

[Dr. Know]

Hi,

I have searched the SQL for Access info I have, but have not been able
to come up with an answer to this problem.

Using VBA and a RunSQL CREATE TABLE command, how do you create a table
that allows certain text fields to be Zero Length.

This is different from NULL.
I can get the Allow NULLs on and off, but not the Zero Length.

This is causing major headaches with subsequent updates from an
externally linked table with some zero length text fields.

For those that might be interested... Here is one answer...

CurrentDB!SQLTable(0).AllowZeroLength = False

I'm talking to myself again...


Dr. Know

 

[Douglas J. Steele]

I don't believe it's possible. I think you have to use either DAO or,
perhaps, ADOX.