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

Retrieve officepath while runnening access

P: n/a
Dear All,

How to retrieve the officepath while running access.

Thanks,

Filip
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
What do you mean by "officepath"?

Where msaccess.exe exists? That's SysCmd(acSysCmdAccessDir)

Where the database itself exists? That's either CurrentProject.Path or
Left$(CurrentDb().Name, Len(CurrentDb().Name) - Len(Dir$(CurrentDb().Name)))

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Filips Benoit" <be***********@pandora.be> wrote in message
news:oM**********************@phobos.telenet-ops.be...
Dear All,

How to retrieve the officepath while running access.

Thanks,

Filip

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.