CODEWITHSUNDEEP
vb.netms-access
Patrick Lisama
Patrick Lisama

Reputation: 11

Access database error “Could not find file”

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?

Upvotes: 0

Views: 1905

Answers (1)

ComputerVersteher
ComputerVersteher

Reputation: 2696

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.

Upvotes: 1

Related Questions