I need to change the length of a field already in use in a table in an Access database. The field is indexed so I cannot delete the field & re-create it in VB without errors.
I can delete the table completely, but I am wondering if there is a way to copy the structure of a table in one database to create or modify a table in another database using VB code.
Any suggestions??
I can delete the table completely, but I am wondering if there is a way to copy the structure of a table in one database to create or modify a table in another database using VB code.
Any suggestions??