This article was previously published under Q291017
There are several ways to change a Microsoft Access table name in a Visual Basic application, some of which include the use of SQL, OLE automation, or Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX).The simplest method is to use ADOX to rename a table.
To use a Visual Basic 6.0 project to change an Access table name programmatically by using ADOX, do the following:
Open a new Standard EXE project in Visual Basic. Form1 is created by default.
On the Project menu, click to select References, and then add references to Microsoft ActiveX data object 2.x library and Microsoft ADO Ext. 2.x for DDL and Security.
Paste the following code into the form load event:
Dim cn As ADODB.ConnectionDim t As TableSet cn = New ADODB.Connectioncn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data Source=C:\biblio.mdb"Dim cat As ADOX.CatalogSet cat = New ADOX.CatalogSet cat.ActiveConnection = cncat.Tables("Authors").Name = "Authors2"'Iterate through the tables collectionFor Each t In cat.Tables If t.Name = "Authors2" Then Debug.Print t.DateModified End IfNextcn.CloseSet cn = Nothing
Save and execute the Visual Basic project, and note that the Immediate window displays the DateModified property value of the "Authors2" table, which is equal to the current day's date.