I don't have the reference here so this is aircode
Application.CurrentProject.Path
is I think the object that returns the path of the currently open database.
Brett
Ilona Wright wrote:
> Hi John,
> I am using the CurDir function to return the current path.
> I am expecting the path of the .mdb using the function, but it returns the
> ACCESS Default Database Folder.
> Can you please tell me how to determine the current path?
>
> I am using Acces 97. What I am trying to do is establish links to
> tables on
> opening my switchboard form. The data tables are in a separate databse to
> the application software, but I expect the tables database to reside
> in the
> same folder as the application software database. So, if the switchboard
> knows where it is, it can establish the links to the data tables. I
> want the
> linking to be hidden from the user.
> I hope this makes sense.
> Thank you again in advance
> Ilona
>
> [Non-text portions of this message have been removed]
>
>
--
Brett Collings
Strengthening Families Administrator
D2D 46422
DDI (04) 916 3422
-------------------------------
This email message and any attachment(s) is intended only for the
person(s) or entity(entities) to whom it is addressed. The
information it contains may be classified as IN CONFIDENCE and may be
legally privileged. If you are not the intended recipient any use,
disclosure or copying of the message or attachment(s) is strictly
prohibited. If you have received this message in error please
notify us immediately and destroy it and any attachment(s).
Thank you. The Ministry of Social Development accepts no
responsibility for changes made to this message or to any
attachment(s) after transmission from the Ministry.
-------------------------------
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Check out the new improvements in Yahoo! Groups email.
http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/