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
