[AccessD] Access 2003 vs Access 2007 VB Question

Check whether you have ADO referenced before DAO.  When you dim the recordset do you set the lib?

dim RSArea1 as dao.recordset?

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 1/31/2012 4:20 PM, Kaup, Chester wrote:
> I moved a database from access 2003 to access 2007. The following statement compiles fine in Access 2003. In access 2007 it generates an error of Compile Error  Method or Data Member not Found. What needs to be different ?
>
> Set RSArea1 = RS4.OpenRecordset
>
>
> Chester Kaup
>
> Engineering Technician
>
> Kinder Morgan CO2 Company, LLP
>
> Office (432) 688-3797
>
> FAX (432) 688-3799
>
>
>
>
>
> No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.
>