Application Path? RESOLVED

Code:

---


Set cn = New ADODB.Connection 'we've declared it as a ADODB connection lets set it.
    cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source= C:\Documents and Settings\Rick\Desktop\~Uni Work~\Poker Buddy\DB1.mdb" 'this is the connection string explained in the notes section.

---

instead of C:\Documents and Settings\Rick\Desktop\~Uni Work~\Poker Buddy\ i just want App.Path & DB1.mdb

but i keep getting an error not sure where to put all the speech marks. Any help ?

"Data Source=" & app.path & "\db1.mdb"

-tg

Oh and they are called Double Quotes, not speech marks ;) :)

grrrr am sure i tried that. Waste of a thread.

Thanks alot :)