Open Access 2007 database (*.accdb) with ASP.net

The new office suite version 2007 comes with brand-new file formats. One of them is the new Access database format version 2007 with accdb extension. Of course there is a new connection string for those new access databases. You can use the connection string below to access your accdb databases through asp.net.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Persist Security Info=False;

In addition, if you are using passwords to access your database, you can include it in your connection string like below;

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Jet OLEDB:Database Password=MyDbPassword;

However, your hosting provider will not be aware of this upgrade or probably you don’t want to install Access 2007 on your server. Actually, you don’t need to. Just install 2007 Office System Driver: Data Connectivity Components

Comments

Hiding / Disabling Maximize and/or Minimize Box in WPF

After trying my hands on the WPF, I realized that I could convert my existing Windows Forms applications into rich looking WPF applications. The task of migration was definitely not easy. During the course of migration, I came across many hurdles and seemed it was impossible to achieve in WPF. But thanks to the msdn help, which made a lot of things easier :-) Since I was converting my existing application, I started looking for the similar features in WPF. The problem I faced was in the initial phase itself where I wanted to disable MaximizeBox button in WPF. This posed a challenge to me since I had no clue as to how to achieve this. After searching the net for a while, I got a solution which I will share with you all to make your life easier. Disabling Maximize Box Button on the WPF Window: This can be done as follows: Put this piece of code above the main class. internal static class WindowExtensions { [DllImport("user32.dll")] internal exte...

Add, Delete and Move controls at runtime.

In this article you will learn how to: Add or delete controls at runtime. Access controls with the indexer. Create control collection using Hash Table. Download full source code. To start with, create a windows application project and add a class to it. We will create a button array so name it as “ButtonArray.cs”. Add the following code to it: Class “ButtonArray” is inherited from the Hash table, so it will be easy for us to add buttons in the collection. Let’s have a look into the “AddButton” method. In this method, we create an instance of a button with the necessary properties and add it to the hash table as well as to the form’s control collection. Each time the control is added in the hash table with its unique key. This helps us to access the controls when required. Now we’ll see how to remove control from the hash table and form’s control collection. In order to remove the control, just pass the key. That’s simple! Isn’t it? :-) Ok! That w...

Create a Virtual Drive through a Command Prompt

Just a few weeks back, I was working on a very old application where in all the directory paths used in the code were hard coded and pointing to a S:/ drive. Since I did not have a drive "S" on my machine, and I had to make the application up and running, I was left two choices: 1. Rename all the directory paths in the application, OR 2. Create a Virtual Drive Option 1 seemed to be a lot time consuming and hence I chose option 2 which I felt was a lot easier to do. I searched on the net, and found out one command which could be used to create virtual drives. Windows OS has an application called " subst" which helps in creating virtual drives mapped to the local folder. The syntax of the command is: SUBST [drive1: [drive2:]path] Example: subst S: C:\Dev When you run this command, a drive will be created with a letter S: assigned to a local folder "Dev" on drive C. This is an easy way to create Virtual Drives, though the drives...

Code In Action

Search This Blog