Data Control - Good or Bad? 2

[BenUK]

I am starting a new project, I am going to build a VB FrontEnd, to an Access DB. I have decided to use ADO as the DB will be upgraded to SQL Server within 12 Months.
I wanted to if there are any limitations in using the ADODataControl, I used the DAO equivalent a while back in a project based on a smaller Access DB, and found it was a convenient shortcut - I just wanted to check if it would still prove a convenient shortcut for a larger project or if it would prove a burden later down the line.

Thanks in advance
Ben

 

[Forri]

Personally i don't like it! it doesn't mean that you shouldn't use it!

it gets slower with larger data sets! i usually create collections and work from there!

goodluck!

Nick

 

[zemp]

I don't use it either. Main reason for me is a lack of control. It does things automatically that you may not need or want. That doesn't mean it harms the data or the applicatin but just that extra processing could be done.

Using just ADO gives you much better control over the data you are using and how you want to use it. You can disconnect the recordset as well freeing up resources.

If you are planning to upgrade to SQL server it may be worth looking at faq709-1526 as well.

zemp

 

[chiph]

The datacontrol is there for two reasons:
[ul][li]Quick & dirty programming tasks ("Wilkins! I need this TPS report by 5pm or you're fired!")[/li]
[li]Novice users who don't necessarily know SQL[/li][/ul]

I'm with zemp, I prefer the control of native SQL, so I haven't used them since VB3.

Chip H.




If you want to get the best response to a question, please check out FAQ222-2244 first

 

[LostInCode]

I also prefer, NOT using the data control.

But, in response to:
>It does things automatically that you may not need or want

You can control everything just the same.
It does have events, contrary to the DAO data control, and properties to set the cursor location, and can be disconnected from the source, to do this with (get control of everything).

Under DAO it was a nightmare though, as these things couldn't be done.