Anyone familiar with MS Access 2000 functionality. Need to have source be relative path and not absolute.
Any help?

Dim db As ADODB.Recordset
Set db = New ADODB.Recordset

text = "Select * From [id_table] WHERE id_num LIKE Me.Form_id

strFile = "provider=microsoft.jet.oledb.4.0;data source=\\KINSERVER6\database.mdb"

db.Open text, strFile, adOpenDynamic, adLockOptimistic