i am having a connectivity error am using vb express 2008 and microsoft access
whwni link it with following code i have an error c:\db1.mdb is not a valid path any solution or code i can use am using window 7




Dim dbProvider As String
Dim dbSource As String

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = C:/db1.mdb"

con.ConnectionString = dbProvider & dbSource

First move the db1.mdb file to the root directory of your application, then use one of the connections below that applies to your application.

' Use this for a windows application
Dim dbProvider As String
Dim dbSource As String

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source=" & System.Environment.CurrentDirectory & "./db1.mdb; User Id=admin;Password=;"
con.ConnectionString = dbProvider & dbSource

' Use this for a web application
Dim dbProvider As String
Dim dbSource As String

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source=" & Server.MapPath("db1.mdb"
con.ConnectionString = dbProvider & dbSource

WHERE IS THE ROOT FOLDER OF MY APPLICATION CAN BE IS IT DRIVE C/PROGRAM FILES OR WHERE MIND YOU I AM USING MSS ACCESS 2007 DATABASE WITH AN EXTENSION OF db1.accdb how can i connect to it

Ok leave your database file on drive C and then try this code below, it should work for Access 2007 .accdb extention.

Dim dbProvider As String
Dim dbSource As String

dbProvider = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
dbSource = "Data Source=  C:\\db1.accdb; User Id=admin;Password=;"
con.ConnectionString = dbProvider & dbSource

wus1:

i am having a connectivity error am using vb express 2008 and microsoft access
whwni link it with following code i have an error c:\db1.mdb is not a valid path any solution or code i can use am using window 7

Dim dbProvider As String
Dim dbSource As String

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = C:/db1.mdb"

con.ConnectionString = dbProvider & dbSource

You are getting the error because the Microsoft.Jet.OLEDB driver cannot see the database. In other words, your path is either wrong or your application does not have read permissions on drive C:\.

Do this quick test:
> paste the string, C:/db1.mdb in Windows Explorer, press Enter. Does the file open? If no, you have found the problem; its a bad path. However, if it opens, you need to check if the user your application is running under has read permissions on C:\.

load vb.net 2008, then goto BUILD menu, click configuration manager,below the active solution platform,click the drop down list for ANY CPU you will see options like NEW,EDIT etc click NEW. NEW SOLUTION PLATFORM DIALOG WILL COME OUT ,instead of x64 pick x86.click close.

go back to ur project folder, under BIN folder you will see x86 folder inside you have debug folder .that is where you will put ur ms access file.mdb

these steps will only work if ur connection string is correct.i.e you normal connection string


if i solved ur problem reached me via 08067361023 , leastpaysolution@yahoo.com

windows is c:\ and not c:/. this slash / is for linux and web paths.

wus1:
Dim dbProvider As String
Dim dbSource As String

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = C:/db1.mdb"

con.ConnectionString = dbProvider & dbSource

@Wus1,

A problem such as yours can keep one up for hours. Did any of the
suggested solutions work for you. If not, try changing the dbSource
line to:

dbSource = "Data Source="Server.MapPath("YourDBName.mdb"

With Server.MapPath, you do not need to specify the location of the DB.
The server will find it. Below is the exact code snippet I used to connect
successfully to an Access web database without specifying the actual location.
Note the use of "&" and "_" to indicate string continuity.

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection"
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & Server.MapPath("Classified.mdb"

Apparently NL code translates apostrophe (") and D to a grinning
face and apostrophe (") and closing bracket to a winking face. Those
were not my intention in the post above. So wherever you see a grinning
face, that's a D and wherever you see a winking face, that's a closing bracket.