none
Can I connect Access to VB if I am using the free VS edition? RRS feed

  • Question

  • Greetings

    I think I read somewhere that a database (Access) could not be connected to VB using the VS free edition.

    I have been making attempts to connect but no success. But there is no message that says it will not work with the free edition? 

    Saturday, November 25, 2017 3:59 PM

Answers

  • NO there are limitations and in lower editions some functionality is unavailable. Working with MS-Access is supported.

    https://www.visualstudio.com/vs/compare/


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    • Marked as answer by Briannnn Friday, December 1, 2017 3:37 PM
    Wednesday, November 29, 2017 3:30 PM
    Moderator
  • This download is no longer avalible
    • Marked as answer by Briannnn Friday, December 1, 2017 3:37 PM
    Friday, December 1, 2017 3:37 PM

All replies

  • I don't know for sure, if you have the following "Data Source" and when the window appears 

    It shows

    Then

    You can use data wizards, other wise you would need to code the functionality yourself.

    Examples

    https://code.msdn.microsoft.com/Working-with-data-in-a-e24664d9?redir=0

    https://code.msdn.microsoft.com/Adding-new-records-into-53ce3eb1?redir=0

    http://www.vb-tips.com/dbpages.aspx?IA=AD2

    Are just a few


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Saturday, November 25, 2017 4:23 PM
    Moderator
  • Hi Briannnn,

    In addition to Kareninstructor' post, you can also following step.

    Open a connection to the Access database
    1. On the View menu, click Server Explorer.
    2. In Server Explorer, right-click Data Connections, and then click Add Connection.
    3. In the Data Link Properties dialog box, click the Provider tab.
    4. In the OLE DB Provider(s) list, click Microsoft Jet 4.0 OLE DB Provider, and then click
      Next.
    5. Click the Connection tab, and then click the ellipses button (...).
    6. Locate the Access database testdb.mdb file that you created by following the corresponding path on your computer.
    7. Select the testdb.mdb file, and then click Open.
    8. In the Data Link Properties dialog box, click OK.

    Best Regards,

    Cherry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, November 27, 2017 3:36 AM
    Moderator
  • Greetings

    I think I read somewhere that a database (Access) could not be connected to VB using the VS free edition.


    You made me curious. 

    Where?


    Success
    Cor

    Monday, November 27, 2017 11:12 PM
  • Here is the error
    Wednesday, November 29, 2017 3:04 PM
  • I not sure if access is on my machine or in the cloud.

    I purchased access a while back and installed it on an old machine. I then got it from logging on to Microsoft and not really sure how it is installed on the new machine.

     

    Wednesday, November 29, 2017 3:06 PM
  • Wednesday, November 29, 2017 3:10 PM
  • What format is it suppose to be?

    Here are all my attempts 

    Wednesday, November 29, 2017 3:10 PM
  • I think it was in a book from Microsoft press.

    Is the free version without limitations?

    Wednesday, November 29, 2017 3:12 PM
  • NO there are limitations and in lower editions some functionality is unavailable. Working with MS-Access is supported.

    https://www.visualstudio.com/vs/compare/


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    • Marked as answer by Briannnn Friday, December 1, 2017 3:37 PM
    Wednesday, November 29, 2017 3:30 PM
    Moderator
  • I not sure if access is on my machine or in the cloud.

    I purchased access a while back and installed it on an old machine. I then got it from logging on to Microsoft and not really sure how it is installed on the new machine.

     

    Do you have 32-bit Microsoft Office installed? If not then you need to install the 32-bit Access Database Engine components:

    https://www.microsoft.com/en-us/download/details.aspx?id=23734


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Wednesday, November 29, 2017 3:33 PM
  • This download is no longer avalible
    • Marked as answer by Briannnn Friday, December 1, 2017 3:37 PM
    Friday, December 1, 2017 3:37 PM
  • This download is no longer avalible

    Yes it is, I just downloaded it.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Friday, December 1, 2017 4:18 PM