Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Defined Size
Message
From
19/07/2002 11:58:20
 
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Miscellaneous
Thread ID:
00680391
Message ID:
00680492
Views:
19
>I have been learning the ADOX model to manipulate an exisiting Microsoft Access database. My question concerns Field Size on a text field. Any way to change it programatically?

Try the following:
oCn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myfolder\db1.mdb;"
oCn.Execute "ALTER TABLE [myTable] ALTER COLUMN [Column3] text(20);", ,adExecuteNoRecords
It's not ADOX but it should work. HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform