Dim str As String
Dim db As Database
sdbname = App.Path + "\net1.mdb"
Set db = OpenDatabase(sdbname, ,"pwd=a")
Set db = OpenDatabase(sdbname,true ,"pwd=a")
老是报错,不知道为什么?
Dim db As Database
sdbname = App.Path + "\net1.mdb"
Set db = OpenDatabase(sdbname, ,"pwd=a")
Set db = OpenDatabase(sdbname,true ,"pwd=a")
老是报错,不知道为什么?
Set dbsCurrent = OpenDatabase("DB1.mdb")
Set qdfBestSellers = dbsCurrent.CreateQueryDef("")
With qdfBestSellers
.Connect = "ODBC;DATABASE=pubs;UID=sa;PWD=;" & _
"DSN=Publishers"
.SQL = "SELECT title, title_id FROM titles " & _
"ORDER BY ytd_sales DESC"
Set rstTopSeller = .OpenRecordset()
rstTopSeller.MoveFirst
End With
Dim rs As Recordset
Set cn = Workspaces(0).OpenDatabase(App.Path & "\store.mdb", False, False, "MS Access;PWD=***")
Set rs = cn.OpenRecordset("tablea", dbOpenTable)