change table name

  • Thread starter Thread starter A
  • Start date Start date
A

A

thank you
1- how can i change table name to new name in code or by macro?
2- How can i change field name in table to new name by macro or vba os sql
thank you
 
A said:
thank you
1- how can i change table name to new name in code or by macro?
2- How can i change field name in table to new name by macro or vba os sql
Click to expand...


You can open the other database and use the standard DAO
properties to manipulate the table/field names. For
example:

Dim db As Database
Set dbOther = OpenDatabase("path to other database")

With dbOther.TableDefs("old table name")
.Fields("old field name").Name = "new field name"
.Name = "new table name"
End With
 
Back
Top