Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
I have a problem with connecting the MS access database with web application in Vb language. I'm using the Visual Studio 2010 and MS access 2010.If you know the correct coding and the way of connection, and add data to the database with text box, please reply.
Posted 17-Jan-11 1:44am
Edited 17-Jan-11 2:16am
[raju.m][makhaai] at 17-Jan-11 6:57am
google your question you will get number of answers. if you need connection string go to
I changed your tags because many of them were redundant - If it's involving hooking up a database, the tag "winforms", web development", and "visual studio" are not necessary.
Rate this: bad
Please Sign up or sign in to vote.

Solution 3


Here is complete working code
 string ConnectString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("db\\database.mdb;");
        OleDbConnection objCon;
        OleDbCommand objCmd;
        DataSet Ds = new DataSet();
        string GetSql = string.Empty;
        GetSql = "(SELECT * FROM table)";
        using (objCon = new OleDbConnection(ConnectString))
            using (objCmd = new OleDbCommand(GetSql, objCon))
                OleDbDataAdapter Da = new OleDbDataAdapter(objCmd);
You have to just convert it into
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load
dim dbconn
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
end sub
SMRITI1231 at 13-Jul-13 10:25am
Is working with with Access at background advisable or are there better database options
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Googled the phrase " ms-access database", and among the 6.5 MILLION hits returned by google:[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 495
1 Sergey Alexandrovich Kryukov 479
2 OriginalGriff 360
3 CHill60 280
4 CPallini 250
0 Sergey Alexandrovich Kryukov 10,017
1 OriginalGriff 9,495
2 Peter Leow 5,241
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 3,076

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 17 Jan 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100