Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2004
    Posts
    34

    Unanswered: Could anyone recommend a tutorial for..

    I'm using VB to access MDBs, and now I want to expand my work to a SQL server. Does anyone know where someone of my needs can find a suitable tutorial?

    Thanks in advence,

    Chen

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    What are you wanting a tutorial on? Not clear...
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  4. #4
    Join Date
    Mar 2004
    Posts
    34
    I know how to connect to an access database using VB.

    I want to connect to an SQL server instead. And I want the transfer to be as swift as possible as I don't want to reprogram everything I did..

    But I don't know nothing about SQL servers.

    Though I did heard they're relatively easy to move to if you already used access..

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by Wolverchenus
    I know how to connect to an access database using VB.

    I want to connect to an SQL server instead. And I want the transfer to be as swift as possible as I don't want to reprogram everything I did..

    But I don't know nothing about SQL servers.

    Though I did heard they're relatively easy to move to if you already used access..
    Well the short answer is...it depends...

    How do you connect to Access now?

    I've converted several Access apps to sql server...some port ok, others are impossible...

    mostly because the way the front end was written..

    In the final analysis, the best reason to go to sql server is to take advantage of the power of the backend...

    If your using it just for storage, it may be that it'll be slower...much slower...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Mar 2004
    Posts
    34
    It's to allow multiple connections through multiple computers on a network..

    I'm using OLEDB right now. Can we do it Doc?

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, you can do it.

    Since nobody has yet suggested a particular title, I'm willing to go out on a limb and suggest The Hitchiker's Guide by Bill Vaughn. I think it is a great book for someone getting started!

    -PatP

  8. #8
    Join Date
    Mar 2004
    Posts
    34
    Anything lighter and free?

    I'm more of an autodidact.. once someone aims me at the right direction..

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Lighter??? I'll lend you a couple of helium balloons!

    Free? Other than the obvious comment about "you get what you pay for", there are hundreds of sites that could be a significant help there. Check out the VB forum here at dbforums, the Microsoft VB.NET pages, tidbits from Woody's Watch, and quite literally thousands of places around the web.

    -PatP

  10. #10
    Join Date
    Mar 2004
    Posts
    34
    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
  •