ACCESS'97 Forms using ADO Recordset as source:OLEDB 
Author Message
 ACCESS'97 Forms using ADO Recordset as source:OLEDB

I am using ACCESS'97 as front-end to SQL SERVER 7 : I need
convert existing ODBC connections using DAO to ADO using
OLEDB connections.
How can i specify the new recordsource to the form in
code ?

Thank You for any assistence

Sat, 06 Aug 2005 07:14:07 GMT  
 ACCESS'97 Forms using ADO Recordset as source:OLEDB
You can't.

The forms in a97 are DAO.

You can use ADO recordset objects in a97, but you can't use/bind them to a
form. (you can in a2000 and beyond).

On the other hand, I can't imagine why you want to do this anyway...

Albert D. Kallal
Edmonton,  Alberta Canada

Sun, 07 Aug 2005 07:33:13 GMT  
 [ 2 post ] 

 Relevant Pages 

1. ACCESS'97 Forms , ADO Recordsets using OLEDB connections

2. ACCESS'97 Forms using ADO recordsets from OLE DB conn


4. Long delay in opening RecordSet via ADO using JET.OLEDB.4.0 provider

5. Access 2000 - dynamically setting an ADO Recordset as a form source

6. Using ADO Recordset with Forms (ADO vs DAO)

7. ADO OLEDB Provider for Access 97

8. Using Persisted ADO recordset as page source

9. ADO Recordset as a Form Record Source Property

10. Opening second recordset on the same table using DAO in Access '97

Powered by phpBB® Forum Software © phpBB Group