I dont know what do you excatly want to do but you can try this:
db.Execute ("ALTER TABLE table1 ALTER COLUMN column1 Double")
or
db.Execute ("ALTER TABLE table1 ADD COLUMN column1 Double")
ERI1618
Last Activity: Nov 23 '06, 05:39 PM
Joined: Nov 18 '06
Location:
-
Crating access tables from vb code
I am using TableDefs function to update table fields from vb code but i cant give a field the property Indexed Yes (No Duplicates)
Please help.
Thank you. -
Thank you it worked.Leave a comment:
-
creatin a table using access query
I am trying to create a table in Access but i have a syntax error:
I just want to crate a table with default values for excample
create table test (column1 Text(20) DEFAULT 'This is a test')
I know it works in SQL.
Thanks in advance for the help.
No activity results to display
Leave a comment: