4 replies
by anoopitl Accepted solution
by 3xp3rt Accepted solution
by royeschner Accepted solution
'declare in Module - sub Main()
Public gstrConnectionString As String
gstrConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\MyDB.mdb";Persist Security Info=False"
''''''''''''''''''''''''''''''''''''''''
'assign global connection string to the connection
Set cn = New ADODB.Connection
cn.ConnectionString = gstrConnectionString
cn.Open
'recordset processing
Dim alphaRS As ADODB.Recordset
Dim strQuery As String
Set alphaRS = New ADODB.Recordset
strQuery = "Select * From TableName WHERE Enabled=True"
alphaRS.Open strQuery, cn, adOpenKeyset, adLockOptimistic
by tony hopkinson Accepted solution
http://www.blueclaw-db.com/ms_access_examples/
Look for the ADO stuff on the left hand side, half way down.
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending