DataEnvironment Basics

[TheRealDeal]

Can someone get pointed in the right direction in regards to utilizing a simple Select SQL to a Acc 2000 table. I want to be able to hookup to it as though it were a recordset and MoveFirst, MoveLast, ... . I do not have any literature to get me off of the ground and have not discovered anything fruitful(so far) on the web.

 

[BobRodes]

There are lots of ways to do that. Some of them are VB specific, some are more Access specific. I wouldn't use the DataEnvironment. Start by reading up on the ADO object library, and then come back with more specific questions.

HTH

Bob

 

[TheRealDeal]

I am still very interested in learnig how to access the DataEnvironment from code. Would there be someone that would be able to demonstrate how to to get DE, Command, dill into the recordset?

 

[BobRodes]

Well, if you must, you must. Do you have a data environment in a VB project already, that has a command that already pulls a recordset, or do you need help with that first?

Bob

 

[imterpsfan3]

Below is a link that gives you a very basic tutorial on the Data Environment Designer with Visual Basic. Note that the article misspells the Biblio database that comes with Visual Basic. If you don't have that installed, you might try the ubiquitous Northwind database. A very nice feature built within the DED is the ability to create hierarchical or shaped recordsets.

http://abstractvb.com/code/code706.asp

I wouldn't discount the Data Environment Designer (DED). It's useful for small projects and reduces the amount of design time considerably. Being able to drag and drop fields en masse on a form from a command object is useful in building a GUI quickly. You don't have to use the Data Environment after that.

You can do a lot more with the DED than this tutorial discusses. You can also build reports off of the DED as well. The Data Forms wizard also gives you the ability to create a master/detail form via the DED

I wouldn't however use the DED for a scalable application that supports many users.

I'm a rookie but learning...

 

[BobRodes]

<Being able to drag and drop fields en masse on a form from a command object is useful in building a GUI quickly. You don't have to use the Data Environment after that.

I used to do that, and use the DE to find connectionstrings. But now, I use the Data Form Designer addin to do the former, and connectionstrings.com or similar to do the latter.

My feeling is that it's like using the queen mary to ferry people across the Hudson river.