instead of C:\Documents and Settings\Rick\Desktop\~Uni Work~\Poker Buddy\ i just want App.Path & DB1.mdbCode: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.
but i keep getting an error not sure where to put all the speech marks. Any help ?




Reply With Quote