7,763
社区成员
发帖
与我相关
我的任务
分享
Public Function connecttodatabase(strfilename As String) As String
On Error GoTo err_conn
Set g_Conn = New Connection
With g_Conn
.CursorLocation = adUseClient
.CommandTimeout = 5
'连接到Access数据库
.ConnectionString = "provider=microsoft.jet.oledb.4.0;password='';" & "data source=" & strfilename
.Open
End With
connecttodatabase = ""
Exit Function
err_conn:
connecttodatabase = Err.Description
End Function
Public Function GETData(strsql As String) As Recordset '直接执行sql语句
On Error GoTo err_conn
Set g_Conn = New Connection
With g_Conn
.CursorLocation = adUseClient
.CommandTimeout = 5
'连接到Access数据库
.ConnectionString = GetINI("setting", "ConnectionString", "", App.Path & "\setting.ini") ’这句可改为你需要的连接语句
.Open
Set GETData = .Execute(strsql)
End With
Exit Function
err_conn:
MsgBox Err.Description
End Function
Public Function GetINI(ByVal Section As String, ByVal AppName As String, ByVal lpDefault As String, ByVal FileName As String) As String
Dim Str As String
Str = Space(256)
Call GetPrivateProfileString(Section, AppName, lpDefault, Str, Len(Str), FileName)
GetINI = Left(Str, InStr(Str, Chr(0)) - 1)
End Function