open self database

[stephane]

hi
using selects queryes with DAO works well.
i've got a code
Set MyDB = OpenDatabase("C :\folder\voyage s.mdb")

but i want make datebase with independent path, so user can put it into other folders and it must works.
is any methods to open self base, don't using self path?
or is any methods to determine self path?

[NeoPa]

Look in CurrentDB.Name.
You will have to extract it from the full name by finding the last "\" char.

[stephane]

i find solution

Set MyDB = CurrentDb()

it works)

[NeoPa]

I didn't understand that that was what you needed - sorry.
You got your answer anyway, so that's good.