Renaming existing table fields from code

C

Charles Tam

I would like to rename several MS Access 97 table fields from code. In
addition, I would like to increase their field size?

How could this be implemented? What are my options?
 
O

Ofer

Search the group on "Alter table" you'll find what you looking for
For example something writen by Allen Browne in prev post

Try executing a DDL query statement, e.g.:

strSql = "ALTER TABLE Table1 ALTER COLUMN Field1 DOUBLE;"
dbEngine(0)(0).Execute strSql, dbFailOnError

For a list of the names to use in DDL and how they match the field types in
Access, see:
Field type names (JET, DDL, DAO and ADOX)
at:
http://members.iinet.net.au/~allenbrowne/ser-49.html
 
O

Ofer

There is a good reply on this subject, look for "Find - Find Next" in forms
coding.
I think that will answer your question.
 
C

Charles Tam

Thank for your information.

Ofer said:
There is a good reply on this subject, look for "Find - Find Next" in forms
coding.
I think that will answer your question.
Click to expand...
 
Top