Working with Microsoft Access with VB.NET

  • Thread starter Thread starter Kareninstructor
  • Start date Start date
K

Kareninstructor

Guest
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.

1394056.png

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

1394057.png




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
7218100.png

Continue reading...
 

Similar threads

K
Replies
0
Views
140
Kareninstructor
K
K
Replies
0
Views
212
Kareninstructor
K
K
Replies
0
Views
104
Kareninstructor
K
K
Replies
0
Views
155
Kareninstructor
K
Back
Top