Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Looking for some thoughts (VB6 & DataBases)

    I'm an old fart who used to program in dBaseIV. When AshtonTate came out with DbaseV I got mad because they did not include the developer stuff like they used to do. I haven't programmed seriously for over 10 years. I'm trying to get back in shape and would like to find a good book about programming databases with VB6. If it helps me to get an MCP, good. Any guidance is appreciated. Thanks in advance!

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking for some thoughts (VB6 & DataBases)

    i suggest starting with a copy of Access. There's so much built into the application that 'programming' is 'less required' these days.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Looking for some thoughts (VB6 & DataBases)

    Most people experienced with Access much prefer to use Access to create front end applications rather than a generic programming language. Since you are basically starting over in programming

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking for some thoughts (VB6 & DataBases)

    I definitely recommend Access rather than VB if you want to program databases. There are things that are a breeze in Access that are difficult to impossible in VB without using third part controls.

    If you just want to build VB programs that happen to *use* databases, try "Beginning Visual Basic 6 Database Programming" by John Connell and be prepared for a radical paradigm shift. Event driven, object-based programming is totally different from the procedural stuff you wrote in dBase.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking for some thoughts (VB6 & DataBases)

    My thanks to PeterNRoth, jscher2000 and charlotte for their advice. If I may, I would like to expand as follows:
    I feel comfortable with Access. I've read 4 VB books from John Smiley and the Connell book. I've done studying on ADO. As far as theory is concerned, I feel coMfortable with what I've read. I'm doing all this reading, and all the reading that I sure I got left, to see if I can work my way into an entry level position using either VB or some form of DataBase programming. The question is, should I limit myself to Access? Thanks in advance for any guidance!

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking for some thoughts (VB6 & DataBases)

    I'd get MOUS certified in Access and both MCP certifications in Visual Basic. For the desktop MCP, maybe use the <A target="_blank" HREF="http://www.microsoft.com/MSPress/books/3162.asp">Desktop Applications with Microsoft
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  7. #7
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking for some thoughts (VB6 & DataBases)

    This question is harder to answer. MS is moving to VB.net, which is a different animal than vb6. i've seen several programmers abandon vb entirely for Delphi because they no longer trust a company that has made their old programs obsolete. So now that you're comfortable - too late, the rules have changed again!

    VBA, which is different from vb6 & vb.net, hasnt changed in the latest MS change, but who knows?

    Your question is essentially "now, what!?", which is the standard developer question.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking for some thoughts (VB6 & DataBases)

    Actually, VBA is a subset of VB, and both Office 2000 and Office XP are based on VBA6, which is why there was no significant change in the programming language between Office versions.

    There is also a significant lag between the release of completely new versions of a language (like VB.Net) and the adoption of that language and related technology by companies who hire programmers. There are good economic reasons for that, and there are plenty of companies around who are still using VB4 or earlier technology. My own employer is still marketing an Access 97 based commercial product. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    The companies who will jump on the .Net bandwagon early are those that are heavily into web-based development. Most of the market will lag behind, which gives those who want to be developers a chance to establish themselves in a proven technology and gain some experience while learning a new technology for going forward.
    Charlotte

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking for some thoughts (VB6 & DataBases)

    Once again, my gratitude to those of you who assisted me with your thoughts. Just for fun, one day I will let you know how everything worked out. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •