16 items found in the MS Access Category
Storing Files and Images in Access with ASP.NET
Mikesdotnetting
-
06 December 2009 19:46
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 ...
Filed under:
MS Access
ASP.NET 3.5
ASP.NET Web Forms
as
Tutorial
Viewed: 19683 times
MS Access Date and Time with ASP.NET
Mikesdotnetting
-
13 December 2008 21:47
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 ...
Filed under:
MS Access
ASP.NET 3.5
as
Tutorial
Viewed: 28649 times
Import Data From Excel to Access with ASP.NET
Mikesdotnetting
-
09 July 2008 09:19
Building on my previous article on importing text files of various formats to an Access database, here's how to do the same thing simply and efficiently with Excel files.
Click to read more about Import Data From Excel to Access with ASP.NET ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
ASP.NET Web Forms
as
Tutorial
Viewed: 48429 times
AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET
Mikesdotnetting
-
17 May 2008 09:48
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.
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
ASP.NET Web Forms
as
Tutorial
Viewed: 56436 times
80040E14 - MS Access Syntax Error messages
Mikesdotnetting
-
01 May 2008 11:06
This short article deals with the following common MS Access-related error messages:
Click to read more about 80040E14 - MS Access Syntax Error messages ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
ASP.NET Web Forms
as
Tutorial
Viewed: 17379 times
Simple Login and Redirect for ASP.NET and Access
Mikesdotnetting
-
01 May 2008 10:02
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 ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
ASP.NET Web Forms
as
Tutorial
Viewed: 133342 times
Solving the Operation Must Use An Updateable Query error
Mikesdotnetting
-
30 April 2008 22:48
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 ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
ASP.NET 3.5
as
FAQ
Viewed: 105673 times
Migrating from Sql Server to Access in ASP.NET
Mikesdotnetting
-
16 November 2007 10:45
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 ...
Filed under:
MS Access
ADO.NET
as
Tutorial
Viewed: 10481 times
An ASP.NET Search Engine with MS Access for optional search criteria
Mikesdotnetting
-
12 November 2007 15:15
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 ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
ASP.NET Web Forms
as
Tutorial
Viewed: 19090 times
Reading Text files into Access with ASP.NET
Mikesdotnetting
-
09 September 2007 21:20
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 ...
Filed under:
MS Access
ADO.NET
as
Tutorial
Viewed: 29653 times
Getting the identity of the most recently added record
Mikesdotnetting
-
05 June 2007 22:13
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 ...
Filed under:
SQL
SQL Server Express
MS Access
ADO.NET
as
Tutorial
Viewed: 181821 times
Binding data to a DropDownList with ADO.NET
Mikesdotnetting
-
11 May 2007 22:35
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 ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
as
Snippet
Viewed: 6556 times
Analyse the tables and saved queries in an Access database with ADOX
Mikesdotnetting
-
06 May 2007 22:34
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 ...
Filed under:
Classic ASP
VBScript
MS Access
as
Snippet
Viewed: 4052 times
Parameter Queries in ASP.NET with MS Access
Mikesdotnetting
-
13 April 2007 22:17
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 ...
Filed under:
ASP.NET 2.0
MS Access
ADO.NET
as
Tutorial
Viewed: 116544 times
Saved Parameter Queries with MS Access and ASP
Mikesdotnetting
-
31 March 2007 21:19
Protecting your application against SQL injection and easier debugging are just two of the benefits of using saved parameter queries in MS Access.
Click to read more about Saved Parameter Queries with MS Access and ASP ...
Filed under:
Classic ASP
VBScript
MS Access
as
Tutorial
Viewed: 9171 times