Access database error “Could not find file”

Question

When I run my program in Visual Studio, The message pops up, The file name and the file name in the Visual Basic is the same SUPPLIER_QUOTATION.

I already tried renaming the file but did not seems to work.

Public Sub connection()
    cn = New OleDb.OleDbConnection
    With cn
        .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "SUPPLIER_QUOTATION.mdb"
        .Open()
    End With
End Sub

Could not find file 'C:\Users\Patrick Echenique\Documents\Visual Studio 2012\Projects\SUPPLIER QUOTATION\SUPPLIER QUOTATION\bin\DebugSUPPLIER_QUOTATION.mdb'.

How do I solve the problem?

ComputerVersteher · Accepted Answer · 2019-07-26 07:12:51Z

1

You miss a backslash\in front of filename!

Path should be:

C:\Users\Patrick Echenique\Documents\Visual Studio 2012\Projects\SUPPLIER QUOTATION\SUPPLIER QUOTATION\bin\Debug\SUPPLIER_QUOTATION.mdb

Change code to:

.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
                    Application.StartupPath & "\SUPPLIER_QUOTATION.mdb"

UPDATE (suggested by @Jimi):

.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\SUPPLIER_QUOTATION.mdb"

I am not sure about the benefits of |DataDirectory|, but I am a novice in VB.Net.

edited Jul 26, 2019 at 7:12

answered Jul 26, 2019 at 2:44

ComputerVersteher

2,6941 gold badge12 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Jimi Over a year ago

.ConnectionString = "(...);Data Source=|DataDirectory|\SUPPLIER_QUOTATION.mdb"

Jimi Over a year ago

The use of |DataDirectory| instead of Application.StartupPath.

Jimi Over a year ago

No need for me to edit your answer. You already provided an example and a link, which includes the definition and specify its usage. Future readers may find your answer more useful this way.

Jimi Over a year ago

This is a common feature, not related to a specific language. It comes from System.Data.Common.DbConnectionOptions

ComputerVersteher Over a year ago

Common for .Net. But not on VBA ;(. As a compensation, Ms Access has SubForms (and I won't swap them for .Net) :D

Collectives™ on Stack Overflow

Access database error “Could not find file”

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related