Can we use ADO programming in Access 97?

[SAG]

One of my clients wants me to write an Access VBA program
for his older equipment. I started a new blank database
and added a connection object and set it up:

Public adoConnection as Connection, Dim rs as recordset
--------------------------------------------------
Public Sub OpenConnection()

'Create the global connection

adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Client\ClientData.mdb;"

End Sub

When I attempted to add:

Set rs = new ADODB.Recordset
it wasn't available in the popup menu. Can I use ADO in
Access 97? Do I need to download a DLL file?

Please advise,

STeve

 

[Jake]

In the VBA editor, click Tools > References, then make
sure that Microsoft ActiveX Data Objects 2.x is checked.

Jake

 

[Larry Linson]

Why would you want to use ADO with a Jet database? DAO is the native
language of Jet, it is faster than ADO for accessing Jet, and it is more
complete than the combination of ADO and ADOX.

All that said, yes, you can, but it is strictly via VBA and can't be bound
to forms, and Access 97 cannot create an ADP.

Larry Linson
Microsoft Access MVP