Converting from Data Environments to Pure Code

Heya.

This post is a follow-up to this post. I didn't have any luck figuring out my Data Environment problem, so I am hoping to convert to pure code.

How difficult is it to convert? I know how to open connections and manipulate the data in code, but I don't know exactly how Data Environments are implemented (are they global recordsets? etc.).

Does anyone have any suggestions as to how to easilly migrate from Data Environments to code? Or have any references to web articles discussing this?

Any help is greatly appreciated!

Thanks,
Enigma

To me the migration would be easy.

Toss the DataEnvirnoment out the window and redo everything with code. :thumb:

Hehe. While I would love to do this, this was supposed to be a quick task for me to perform. Rewriting the entire program isn't going to be quick.

My biggest question is how do I bind my recordsets to the data controls? I know data binding is frowned upon by many, but this is done all over in this project, and I don't have time(nor do I know enough about the program) to rewrite the entire thing. When I bind a recordset to a control on a form, do I have to keep the connection(that the recordset was created on) open the entire duration that the form is open? If so, do I just open the connection in the load event and close it in the close event?

Thanks,
Enigma