Hi all
I am trying access database to fill a word document. It works fine as I have it now.
I am accessing Access data base as below:
Code:
Dim dbDatabase As Database
Dim rsMedico As Recordset
Dim i As Integer
Dim aResults()
Set dbDatabase = OpenDatabase("C:\Users\Rama\Documents\Medprog\Medico.mdb")
Set rsMedico = dbDatabase.OpenRecordset("Patients", dbOpenSnapshot)
Instead of hard coding as above I like to get db path by code or connect string. I have tried all like getdbpath, getdbfullpath. I get errors like type mismatch,object variable not set etc.
I need a relative path or soft coding so that I can use this any other computer with access database.
Hope somebody can help
Marooned