none
Working with Microsoft Access with VB.NET RRS feed

  • General discussion

  • If you work with Microsoft Access 2007 database I have put together a repository on GitHub using Visual Studio 2017. Using the advise provided may not be for everyone but for those who are just starting out and open to not writing code to work with data in a Windows form then this is for you plus the base logic for much of the code came from working with SQL-Server which means the code flow lends itself to moving from Microsoft Access to SQL-Server with little effort by following the guidelines presented. Out of all of the code there are two parts that are specific to Microsoft Access, working with case and case insensitive searches (SQL-Server is easier in this realm) and connection strings but there is a sibling connection class for SQL-Server in the repository also.

    Visual Studio solution is breakdown into solution views between example front end projects and back end class projects.


    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

    Wednesday, January 23, 2019 12:45 AM
    Moderator