For VB6.0, i would advice you create your projects and the database file in the C:\ drive. You can create a folder there to save projects so when you move your project folder to another system, the name and directory of the Access Dbase file remains the same.
Having said that, here is the code for MS Access connection:
Public conn As New ADODB.connection
Public rs As New ADODB.Recordset
Set conn = New ADODB.connection
conn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\data\DataBaseName.mdb"
thank u so much sir...it helps a lot...sir can you put a comments on your sample code especially line 5-7 so that i can understand it also...more power and God Bless sir...by the way sir i'll mark it now solve....