By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,645 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

open self database

stephane
P: 35
hi
using selects queryes with DAO works well.
i've got a code
Set MyDB = OpenDatabase("C:\folder\voyages.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?
Feb 19 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,494
Look in CurrentDB.Name.
You will have to extract it from the full name by finding the last "\" char.
Feb 19 '07 #2

stephane
P: 35
i find solution

Set MyDB = CurrentDb()

it works)
Feb 19 '07 #3

NeoPa
Expert Mod 15k+
P: 31,494
I didn't understand that that was what you needed - sorry.
You got your answer anyway, so that's good.
Feb 19 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.