ACCESS數(shù)據(jù)庫不支持直接利用SQL語句實(shí)現(xiàn)更改表名，或者字段名，但可以ADOX對(duì)象來實(shí)現(xiàn)，范例代碼如下： 復(fù)制代碼 代碼如下:<% 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 %>
