Error: Not a valid file name ( OleDbException )

Question

I have a simple Access database, which contains one table. Here is it Screenshot

For my Button Load event I have this code

    Dim con As New OleDb.OleDbConnection
    Dim dbProvider As String
    Dim dbSource As String

    dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
    dbSource = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=‪E:\addressBook\AddressBook.mdb"

    con.ConnectionString = dbProvider & dbSource

    con.Open()
    MsgBox("Opened")
    con.Close()

And on con.Open() line I am getting this exception . And I can not understand what is the problem. Maybe the name "con" was the problem, but I changed it to "c" or "con1" but the same exception occurs. Can't understand the reason. Thanks for any solution

Screenshot 2

Does the file exist at that location? is the file locked? do you have permissions to open the file? — Christian Phillips, Aug 04 '14 at 08:43
No it is not locked. And Yes I have all the permissions. And it is located in path that is written in code. — Romo Daneghyan, Aug 04 '14 at 08:49

Christian Phillips · Accepted Answer · 2015-05-06T08:44:41.463

0

I don't think Provider is required here, as you already have it in the source, change...

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=‪E:\addressBook\AddressBook.mdb"

con.ConnectionString = dbProvider & dbSource

to...

dbSource = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=‪E:\addressBook\AddressBook.mdb"

con.ConnectionString = dbSource

Take a look at ConnectionStrings.

A better solution is to add the file to the App_Data folder instead of referencing the file from a local drive. Add the connection string to the config...

<connectionStrings>
    <add name="AccessConnection"
        connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|dbName"
        providerName="System.Data.OleDb" />
</connectionStrings>

edited May 06 '15 at 08:44

answered Aug 04 '14 at 11:35

Christian Phillips

18,399
8
53
82

The same exception :/ – Romo Daneghyan Aug 04 '14 at 11:37
Yeah. The same exception in my program. Please advice. Here is the connection string @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=‪‪G:\Edict18042015.accdb; Persist Security Info=False;"; – Kushan Randima May 06 '15 at 08:25
@KushanRandima, instead of placing the file at the route of your *G* drive, consider adding it to the App_Data folder, and adding a connection string in the config - I'll update the answer now. – Christian Phillips May 06 '15 at 08:41

score 0 · Answer 2 · edited Dec 21 '18 at 09:00

0

put the @ before the connection string. it works for me!

edited Dec 21 '18 at 09:00

Anmol

8,110
9
38
63

answered Dec 21 '18 at 07:08

Razvan Teodorescu

1

Could you explain a bit more as to how this solves the problem? – Nick Dec 21 '18 at 07:27

score 0 · Answer 3 · answered Jul 29 '22 at 16:16

0

I also faced the same problem: but solution is: you must give a correct path of your access database, and don't forget the access file name with its extension (your database and .accdb). I am sure it will be all correct...

answered Jul 29 '22 at 16:16

Aso

1
2

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 04 '22 at 05:54

score -1 · Answer 4 · edited May 18 '16 at 15:30

-1

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load
    Dim dbprovider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\user\Documents\k1.accdb"
    conn.ConnectionString = dbprovider
    conn.Open()

edited May 18 '16 at 15:30

LarsTech

80,625
14
153
225

answered May 18 '16 at 15:00

kshitij

1

You should include an explanation of how this would help users. But it's not looking like a very helpful answer at the moment... – LarsTech May 18 '16 at 15:32

Error: Not a valid file name ( OleDbException )

4 Answers4

Linked