albertkhor
Well-known member
- Joined
- Jan 12, 2006
- Messages
- 150
- Programming Experience
- Beginner
i'm using microsoft access and oledb.
i create a table which name "Product". Inside the "Product" table have 3 field: id, name, price. The name field i set as varchar and size is 50.
But now i want to change the name field size to 100 is that possible? How to do that? If cannot change the size then i think drop table is posible right? but how to copy all the name field data to another field?
i create a table which name "Product". Inside the "Product" table have 3 field: id, name, price. The name field i set as varchar and size is 50.
But now i want to change the name field size to 100 is that possible? How to do that? If cannot change the size then i think drop table is posible right? but how to copy all the name field data to another field?