Tony Goodhew - GUI Computing
Does VB do SQL well? If it does why doesn't it do it for me? SQL Access under Visual Basic is still a black art to the majority of software developers and we have Microsoft's efforts to thank for that. They endeavoured to make a development tool so easy to use and so powerful that they did so by hiding a lot of the complexity of the product, whilst allowing the complex interactions to effect the execution of developed applications.
In this article we'll spend a little time looking at what the data access components are and when should you use them. We will also have a look at some common optimisations for SQL database access under Visual Basic.
History of Visual Basic
Here enters Visual Basic 4.0
Why is my SQL Query almost dead?