applications allways looking on c:/ regardless of connection string

[gobblegob]

for some reason my application is looking for my database in the wrong place
i get an error "cannot find C:/database.accdb"

  Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\database.accdb")
        Dim cmd As New OleDbCommand("SELECT COUNT(*) FROM [users] WHERE Fname = @Fname AND Lname = @Lname AND Password = @Password", conn)

this is in my app.config aswell

 connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\database.accdb"
            providerName="System.Data.OleDb" />

i have searched the whole solution from "C:/database.accdb" but it is nowhere any ideas?

[tlhintoq]

Its on your F: drive

[tlhintoq]

Sorry... just being funny.

i have searched the whole solution for "C:/database.accdb" but it is nowhere any ideas?

Data Source=\database.accdb

It's right here. I'm pretty sure that this causes it to look on the same drive as the running application, which in your case is C:

I suggest you read through these tutorials:
Database How to parts 1 and 2
http://bytes.com/topic/net/insights/...e-your-program
http://bytes.com/topic/net/insights/...rogram-part-ii

[gobblegob]

i got it now changed this

Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\database.accdb")

to,,,

Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\database.accdb")

[Plater]

All you needed was a fully qualified path