Urgent Question on Access RunSQL Create Table Query and Required

  • Thread starter Thread starter Dr. Know
  • Start date Start date
D

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
 
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.
Click to expand...

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

CurrentDB!SQLTable(0).AllowZeroLength = False

I'm talking to myself again...


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