How to bind ADO recordset to a form in Access 97???

[VladimirKim]

Hi.
Access 97 form has a recordsource property, which is basically a string, like "SELECT * FROM Hotels".
But I have a ADO recordset that I would like to bind to a form. How can I do that?
Thanks in advance.

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/281998/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[VladimirKim]

Thanks, but they are referring to Access 2000, and there the form has a Recordset property. But in Access 97 the form does not have a recordset property(

 

[PHV]

So, now you know you can't do it ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[VladimirKim]

No, I still get the feeling that it is possible

 

[VladimirKim]

But how??? Please help

 

[PHV]

But how?
One way is to cease using obsolete and deprecated software by upgrading it ;-)

 

[JoeAtWork]

I'm 99% positive Access97 forms can't bind directly to an ADO recordset. ADO was in its infancy or didn't exist when Access97 was created.

 

[VladimirKim]

How about using temporary tables? If yes, then, how would I implement that?
Thanks.