Click here to Skip to main content
11,477,625 members (75,254 online)
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 Sergey Alexandrovich Kryukov 274
1 Richard Deeming 245
2 _duDE_ 165
3 Tomas Takac 150
4 Sascha Lefèvre 145
0 Sergey Alexandrovich Kryukov 7,675
1 OriginalGriff 7,246
2 Sascha Lefèvre 3,034
3 Maciej Los 2,491
4 Richard Deeming 2,305

Advertise | Privacy | Mobile
Web03 | 2.8.150520.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