Renaming existing table fields from code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
There is a good reply on this subject, look for "Find - Find Next" in forms
coding.
I think that will answer your question.
 
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...
 
Back
Top