[MS_AccessPros] Re: Display backend file path and file name

 

Art

The path is stored in the hidden MSysObjects table. A quick DLookup would be something like:
DLookup("Database", "MSysObjects", "Name='YourTableNameGoesHere'")

To see the tables in 2003, Click on Tools>Options>View. Check the box for System Tables.

In 2007/2010, Right-click the Navigation Pane header. Select Navigation Options.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> Is there a way to display the path and name of the backend file in a text box?
>
> Thanks
>
> Art Lorenzini
> Sioux Falls
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 9
• New Links 1
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___