By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,504 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 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,186
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,186
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.