Rename a table in anoter database

[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.

 

[Dirk Goldgar]

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.

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