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

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

Jake


>-----Original Message-----
>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
>
>
>
>
>
>
>.
>

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

"SAG" <(E-Mail Removed)> wrote in message
news:089701c38215$b1be2ae0$(E-Mail Removed)...
> 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
>
>
>
>
>
>