want to change field size by using alter table

F

frustrated

I am using
dbs.Execute "alter table tabname add column SW number"
which works fine BUTTTTT, it adds the column with a field
size of long integer and I NEED it to be 'integer' -- how
can I change this?????

I need an answer ASAP as a project depends on this

Any help you give will be GREATLY appreciated.
 

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

Help with ALTER TABLE statement 14
Question about ALTER TABLE and ALTER COLUMN 7
Alter Back-End Table from Front-End 5
Add New Combobox to table useing code 1
Alter/Change Text Column Field Size 2
Syntax error when changing field size using ALTER TABLE 5
Changing Column Size Through ALTER TABLE SQL Statement 2
Alter Decimal Places property in table with SQL 8

Top