Rename a table in anoter database

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

I would like to rename a table in another database.

I'd like to use DoCmd.Rename (or equilalent) on a table in a database that
is not the active database.

Thanks.
 
JP said:
I would like to rename a table in another database.

I'd like to use DoCmd.Rename (or equilalent) on a table in a database that
is not the active database.
Click to expand...


You could do something like this:

Dim db As DAO.Database

Set db = DBEngine.OpenDatabase("C:\Your Path\To\YourDatabase.mdb")

db.TableDefs("OldTableName").Name = "NewTableName"

db.Close
 
Back
Top