Option Explicit
Dim cmd As New ADODB.Command
Dim db As New ADODB.Connection
Private Sub Form_Load()
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
End Sub
Private Sub Command1_Click()
db.Open
db.Execute ("alter table k rename to 'L'")
db.Close
End Sub
'在访问access好像不行,顶一下,看看有没有方便的方法
'代码引用示例,请给分喔!(别忘记引用ADO和ADOX)
Public g_cnn As New ADODB.Connection
Private Sub cmdModify_Click()
With g_cnn
.Provider = "Microsoft.jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & App.Path & "\data.mdb"
.Open
End With
RenameTableName Me.lstTables, strTableName
刚出炉的代码,请大哥们多多指导
'--------------------------------------------------
' Function: RenameTableName
' Purpose: 利用ADOX重命名数据表名称
' Input:
' [in] DatabseConnectionObject -- 数据库的链接(一般为ADODB.Connection对象)
' [in] strOldName -- 旧表名称。
' [in] strNewName -- 新表名称。
' Output: True: 重命名表名称成功
' False:重命名表名称失败
' Content: None
' Information:
' 编写: 王林 2004/11/20 说明:
' 修改: 王林 2004/11/20 说明:
'--------------------------------------------------
Public Function RenameTableName(DatabseConnectionObject As ADODB.Connection, strOldName As String, strNewName As String) As Boolean
On Error Resume Next
Dim tbl As ADOX.Table, cat As New ADOX.Catalog
Set cat.ActiveConnection = DatabseConnectionObject '设置目录的链接
For Each tbl In cat.Tables
If tbl.Name = strOldName Then tbl.Name = strNewName '重命名表的名称
Next
If Err.Number <> 0 Then
RenameTableName = False
'给用户提示信息
'MsgBox C_ErrMsgTitle1 & Err.Number & vbNewLine & C_ErrMsgTitle2 & Err.Description, vbExclamation, C_ErrMsgTitle
Else
RenameTableName = True
End If
End Function
Private Sub Command22_Click()
Dim db As New ADODB.Connection
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb"
db.Open
db.Execute "ALTER TABLE K TO L"
MsgBox "yes"
End Sub