[MS_AccessPros] unrecognized database format...is this a reference problem ?

 

This code worked with MDB, but I am now altering it for accdb. Code is as follows"

Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\E_FORM\" & _
"Database1.accdb;"

rst.Open "Legacy3_filled", cnn, _
adOpenKeyset, adLockOptimistic

Does anything appear wrong? or am I using the wrong reference components ?
Terence

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4
• New Files 5

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___