Re: ADOX in vb6 and access97




"Ricardo Furtado" <RicardoFurtado@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:6615A91D-5774-482E-A69C-F8ED78C70A5A@xxxxxxxxxxxxxxxx
Thank you for your answer
well i'm searching every possibility,...

I found bugs in the code
i just can't do something like
col.Type = myTable.Columns.Item(intContador).Type

because col.Type is readonly
but if i can't do this, how can i change this property?


Some types can't be changed so you can do it in several steps
1) capture the Type of the Field in the existing table.
2) create a new Field in the new table using the information
3) Copy data from old Field to new Field
4) Delete original field
5) Rename new field

But take a look at the ALTER TABLE and DDL with DAO.

As Bob said, this stuff is just easier with DAO.

-ralph


.



Relevant Pages