Be the first to write a review
How to Run MS Access Queries from ASP.NET – Part 1
With ASP.NET version 1.1 it’s a little surprising Microsoft didn’t make working with Access databases a little easier. Visual Studio .NET 2003 and prior were mainly geared towards SQL server integration. Though you can connect to Access databases without issue, you cannot have the Data Access wizards run or create queries within Access for you like it can with stored procedures for SQL server.
The purpose of this tutorial is to achieve exactly that, to be able to connect to an Access database and execute its queries, without the use of the GUI Data wizards. We’ll take this framework and build a simple mini-application with several features over the course of this 2 part series.
Visual Studio .NET running ASP.NET version 1.1 is required for this tutorial. Both VB.NET and C# code samples will be provided. You will also need a version of MS Access
Kevin Koch
Kevin Koch is a senior software engineer with over 8 years experience designing and architecting primarily web based applications. Fresh out of college during the nineties he co-founded Task Solutions and developed several projects with the then popular classic ASP.
During the Dot Com boom Kevin left his position as president and joined a new venture to build an enterprise insurance claim system build upon J2EE technology. After the Dot Com crash Kevin schooled himself to become an expert with .NET technology and is currently freelancing his ASP.NET skills to build enterprise n-tier frameworks using advanced OO methodologies.