using an ADO recordset with an Acc2k form

[sparkane]

I've currently building an A2k db that uses ADO.

I've read that a2k forms will accept an ADO recordset as read-only, and
I have working code that does this. I have some questions.

-) The test form I've used to receive the ADO recordset does not display
the data; it turns blank when I pass the ADO rs to it. Has anyone fixed
this problem before?

-) I'm going at some point to create a form which allows editing of
data; and so for those cases I'll have to extract the data from the ADO
recordset. Any suggestions about the best way then to load that data
into an a2k form? Can I copy the data to a DAO recordset and just
insert that into the form?

thanks in advance
spark

 

[Steve M.]

What is the code you are using to create/set the recordset of your form?
The recordset var needs to be at the module declares level and not inside a method.

Unlike ADO, DAO cannot exist only in memory it needs a saved structiure to exist, some people use temp tables other use arrays.

Things will be so much easier if you can upgrade to 2002 or 2003 where ADO recordsets are editable.