ACCESS數據庫不支持直接利用SQL語句實現更改表名,或者字段名,但可以ADOX對象來實現,範例代碼如下:
複製代碼代碼如下:<%
CallRenameTable("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:/example.mdb","test","changed")
SubRenameTable(conStr,oldName,newName)
'HastobeOLEDBconnection
'CreateobjectandconnecttoDB...
DimobjADOXDatabase
SetobjADOXDatabase=Server.CreateObject("ADOX.Catalog")
objADOXDatabase.ActiveConnection=conStr
'Changethename...
objADOXDatabase.Tables(oldName).Name=newName
'Cleanup...
SetobjADOXDatabase=Nothing
EndSub
%>