One minor note...
The Connect field is only for ODBC tables. Access tables use the Database field to show the path.
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, John Viescas <JohnV@...> wrote:
>
> Art-
>
> Yes, the database has to be split. Your original question:
>
> "Is there a way to display the path and name of the backend file in a text box?"
>
> The word "backend" implies it's split, and you're trying to display the location of the linked tables.
>
> If you want the current location of the "code" database, use:
>
> CurrentProject.FullName
>
> By the way, you can also find the location of a linked table by looking at the Connect property of the TableDef object.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> --------------------------
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
> Sent: Thursday, April 05, 2012 2:34 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Display backend file path and file name
>
>
> Duane,
>
> I tried:
> SELECT Database
> FROM MSysObjects
> WHERE Name='tblUnit'
>
> And it returned a blank record. Then I tried:
>
> SELECT Database
> FROM MSysObjects
>
> It returned 746 rows which were all blank. The only thing that pops out at me is, does this only work with the database is split?
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: Duane <duanehookom@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, April 4, 2012 9:46 PM
> Subject: [MS_AccessPros] Re: Display backend file path and file name
>
>
>
>
> Jim,
> Create a query with this SQL:
> SELECT Database
> FROM MSysObjects
> Where Name="NewHires";
>
> What do you see?
>
> Duane
>
> --- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@> wrote:
> >
> > Bill,
> >
> > I think I will need a dollar. I added it to my form load event added the text box with the exact name as txtFileLocation and I still see nothing in the text box.
> >
> > Me.txtFileLocation = DLookup("Database", "MSysObjects", "Name='NewHires'")
> >
> > Ã
> > Jim Wagner
> > ________________________________
> >
> >
> >
> > ________________________________
> > From: Art Lorenzini <dbalorenzini@>
> > To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
> > Sent: Wednesday, April 4, 2012 3:17 PM
> > Subject: Re: [MS_AccessPros] Re: Display backend file path and file name
> >
> >
> > Ã
> > My two cents
> > Ã
> > I put it in my form load.
> > Ã
> > Private Sub Form_Load()
> > Ã Me.txtFileLocation = DLookup("Database", "MSysObjects", "Name='tblUnit'")
> > Ã
> > End Sub
> >
> > With warm regards,
> >
> > Arthur Lorenzini
> > Sioux Falls, South Dakota
> >
> > ________________________________
> > From: Jim Wagner <luvmymelody@>
> > To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
> > Sent: Wednesday, April 4, 2012 5:08 PM
> > Subject: Re: [MS_AccessPros] Re: Display backend file path and file name
> >
> >
> > Ã
> >
> > Bill,
> >
> > I cannot get the expression to work. I kind of came into the thread a little late. I put it on a text box on a form. Can you explain it a little clearer for the challenged.
> > Ã
> > Jim Wagner
> > ________________________________
> >
> > ________________________________
> > From: Bill Mosca <wrmosca@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Wednesday, April 4, 2012 2:42 PM
> > Subject: [MS_AccessPros] Re: Display backend file path and file name
> >
> > Ã
> > You're welcome, Art. If you poke around in the system tables you'll find all kinds of cool stuff.
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@> wrote:
> > >
> > > Biil,
> > > That was outstanding.Ãâà I like it when it's that simple... :)
> > >
> > >
> > >
> > > With warm regards,
> > >
> > > Arthur Lorenzini
> > > Sioux Falls, South Dakota
> > >
> > >
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: Bill Mosca <wrmosca@>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Wednesday, April 4, 2012 4:07 PM
> > > Subject: [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
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
Kamis, 05 April 2012
[MS_AccessPros] Re: Display backend file path and file name
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar