Alter table query query

M

MikeR

I can alter a data type with this statement.
ALTER TABLE settings
ALTER COLUMN age text(20)

With an ALTER TABLE query, can I AllowZeroLength=True (or set any of the other properties)?

Thanks,
MikeR
 
J

John Vinson

I can alter a data type with this statement.
ALTER TABLE settings
ALTER COLUMN age text(20)

With an ALTER TABLE query, can I AllowZeroLength=True (or set any of the other properties)?

Thanks,
MikeR
Click to expand...

I don't believe so, not in a JET database. You'll need to use VBA
code.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access VBA question 0
Alter Table/Column to RTF 6
File sharing lock count exceeded. Increase MaxLocksPerFile registry 4
Change Text to Integer Using a Query/Data Definiation Query 3
alter table, please help with syntax error 3
"Read Only" Query 0
SQL Syntax to rename a field in a Table 11
ALTER TABLE 2

Top