17 items found in the MS Access Category

Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Thursday, July 23, 2015 8:05 PM

MS Access ADO.NET EPPlus

There are a number of reasons why you might get "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" error when attempting to connect to either an accdb or an xlsx file, depending on what you are doing. This article discusses some of the causes and provides solutions first for uses involving ASP.NET, and then looking at other application uses.

Click to read more about Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine ...

Viewed 177 times

0 Comments for this item

Storing Files and Images in Access with ASP.NET

Sunday, December 6, 2009 7:46 PM

MS Access ASP.NET 3.5 ASP.NET Web Forms

Should you store files and images in the database or the filesystem in an ASP.NET application?  With SQL Server this is a dilemma, with both approaches having their pros and cons.  When it comes to Access, the decision is much easier to make.  Because an Access database is restricted to 2Gb, it makes more sense to store files in the file system.  However, sometimes, you may not have the choice. If you have to use the database, here's how.

Click to read more about Storing Files and Images in Access with ASP.NET ...

Viewed 36703 times

7 Comments for this item

MS Access Date and Time with ASP.NET

Saturday, December 13, 2008 9:47 PM

MS Access ASP.NET 3.5

Getting odd results and unexpected errors when working with Dates and Times in Access through ASP.NET is a common problem. Here's an overview of the Access DateTime data type, and some resolutions to the more frequently encountered errors.

Click to read more about MS Access Date and Time with ASP.NET ...

Viewed 50677 times

6 Comments for this item

AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET

Saturday, May 17, 2008 9:48 AM

ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms

There are a variety of options for connecting to Access databases within ASP.NET pages. This article attempts to cover the choices and offer recommendations for getting the best out of Access.

Click to read more about AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET ...

Viewed 91427 times

13 Comments for this item

80040E14 - MS Access Syntax Error messages

Thursday, May 1, 2008 11:06 AM

ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms

This short article deals with the following common MS Access-related error messages:

Click to read more about 80040E14 - MS Access Syntax Error messages ...

Viewed 28368 times

6 Comments for this item

Simple Login and Redirect for ASP.NET and Access

Thursday, May 1, 2008 10:02 AM

ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms

Quite often, I see questions asked about creating a simple login page for use with Access from people who don't want to take advantage of the built-in Forms Authentication framework within ASP.NET. The following samples show how relatively easy this is to accomplish.

Click to read more about Simple Login and Redirect for ASP.NET and Access ...

Viewed 318235 times

36 Comments for this item

Solving the Operation Must Use An Updateable Query error

Wednesday, April 30, 2008 10:48 PM

ASP.NET 2.0 MS Access ADO.NET ASP.NET 3.5

The unbelievably cryptic Operation Must Use An Updateable Query error is the bane of developers who are just starting out with Access and ASP.NET. You've done your code, plopped your database file in the App_Data folder (or at least, you should have done), and try to run a page that INSERTs or UPDATEs records, and it all stops dead. This brief article explains the cause of the error, and the steps required to stop it recurring.

Click to read more about Solving the Operation Must Use An Updateable Query error ...

Viewed 206309 times

48 Comments for this item

Migrating from Sql Server to Access in ASP.NET

Friday, November 16, 2007 10:45 AM

MS Access ADO.NET

Yes, you did read that correctly. Here's the situation: you know that Sql Server is by far the superior database system (if indeed MS Access can be called a database system). You also know that MS Access databases are not recommended as a data store for web applications. You are comfortable with Sql Server, and haven't really looked at Access for years - if at all. But now, your boss or your client wants you to use it in the next project.

Click to read more about Migrating from Sql Server to Access in ASP.NET ...

Viewed 21122 times

6 Comments for this item

An ASP.NET Search Engine with MS Access for optional search criteria

Monday, November 12, 2007 3:15 PM

ASP.NET 2.0 MS Access ADO.NET ASP.NET Web Forms

Creating a search interface for one user-supplied value is pretty straightforward: a TextBox for input, a Button and some SQL that searches one or more fields where the values are LIKE '%' + @searchterm + '%' is all that is needed. While it works, this approach is not very flexible. For example, what if you wanted to search for an Employee whose last name contains "a", and don't want those where the first name or city contains "a"? The traditional solution to this is to dynamically construct the SQL statement based on what values were passed by the user. However, building the SQL string can get repetitive, boring and messy. Here is a cleaner way to allow the user to narrow down searches across multiple criteria with the use of optional parameters, and just 3 lines of programming code.

Click to read more about An ASP.NET Search Engine with MS Access for optional search criteria ...

Viewed 27110 times

4 Comments for this item

Reading Text files into Access with ASP.NET

Sunday, September 9, 2007 9:20 PM

MS Access ADO.NET

The Jet 4.0 OLEDB driver is a remarkable beast. Not only will it allow connections to MS Access .mdb files and MS Excel spreadhseets, but it will also allow you to connect to and query a variety of text file formats. Here are some examples that illustrate this capability when applied to importing text based data into Access.

Click to read more about Reading Text files into Access with ASP.NET ...

Viewed 42725 times

5 Comments for this item

Getting the identity of the most recently added record

Tuesday, June 5, 2007 10:13 PM

SQL SQL Server Express MS Access ADO.NET

The built-in functions @@Identity and Scope_Identity() are designed to retrieve the most recently added record's autoincrement identity value from Access and Sql Server respectively. Here are some usage examples.

Click to read more about Getting the identity of the most recently added record ...

Viewed 334831 times

44 Comments for this item

Binding data to a DropDownList with ADO.NET

Friday, May 11, 2007 10:35 PM

ASP.NET 2.0 MS Access ADO.NET

Using ADO.NET to pull data from the Northwind database (Access version), using the saved query Current Product List.

Click to read more about Binding data to a DropDownList with ADO.NET ...

Viewed 12233 times

0 Comments for this item

Analyse the tables and saved queries in an Access database with ADOX

Sunday, May 6, 2007 10:34 PM

Classic ASP VBScript MS Access

The following code will enumerate the tables and their properties, together with the queries in an Access database. Saved SELECT queries are referenced using the Views collection, and INSERT, UPDATE and DELETE queries are referenced from the Procedures collection.

Click to read more about Analyse the tables and saved queries in an Access database with ADOX ...

Viewed 6895 times

0 Comments for this item

Parameter Queries in ASP.NET with MS Access

Friday, April 13, 2007 10:17 PM

ASP.NET 2.0 MS Access ADO.NET

A selection of code samples for executing queries against MS Access using parameters.

Click to read more about Parameter Queries in ASP.NET with MS Access ...

Viewed 187151 times

48 Comments for this item

Recent Comments

Justin Kusuma 8/4/2015 7:01 AM
In response to Posting Data With jQuery AJAX In ASP.NET Razor Web Pages
Hi Mike, thanks for replying... I'm looking for more elegant way to provide user feedback. As now...

Arthur 8/3/2015 4:54 PM
In response to Getting the identity of the most recently added record
Thanks Mike, your site is a mine of useful info :)...

MRP 8/3/2015 4:06 AM
In response to Entity Framework Recipe: Many To Many Relationship On The Same Table
my question is about HashSet and ICollection ! why you use this type and why not user Ilist<> and ?...

Arbaz 8/1/2015 3:39 PM
In response to Scheduled Tasks In ASP.NET With Quartz.Net
Hey Mike, What If I want to set a schedule weekly or every Sunday to run. What would the code for I...

Emma 7/31/2015 3:29 AM
In response to How To Send Email In ASP.NET MVC
As mentioned by John Noble, there seems to be something missing in regards to: return...

Satyabrata Mohapatra 7/30/2015 6:42 AM
In response to Implementing Google's EU End User Consent Policy
Thanks.... Learned a lot....

Jaswanth 7/29/2015 1:31 PM
In response to Displaying Google Analytics Data in ASP.NET
Hi Mike, My application uses MVC 1. I need to fetch the data of pages which has top views. I tried...

Sergey 7/28/2015 6:48 AM
In response to Custom TagHelpers in ASP.NET MVC 6
Thanks a lot!...

Dome 7/27/2015 7:55 PM
In response to Posting Data With jQuery AJAX In ASP.NET Razor Web Pages
Hi, I've just created a new project with WebApi & MVC, then created a controller with the following...

Ted Driver 7/26/2015 5:44 PM
In response to How To Send Email In ASP.NET MVC
Thanks for the great example Mike! I noticed in my implementation of your code that if I put some in...