ACCESS數據庫不支持直接利用SQL語句實現更改表名，或者字段名，但可以ADOX對象來實現，范例代碼如下： 復制代碼 代碼如下:<% Call RenameTable("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/example.mdb", "test", "changed") Sub RenameTable (conStr, oldName, newName) 'Has to be OLE DB connection 'Create object and connect to DB... Dim objADOXDatabase Set objADOXDatabase = Server.CreateObject("ADOX.Catalog") objADOXDatabase.ActiveConnection = conStr 'Change the name... objADOXDatabase.Tables(oldName).Name = newName 'Clean up... Set objADOXDatabase = Nothing End Sub %>
