ACCESS FEED: [MS_AccessPros] Re: Path of back-end in Access 2007

Senin, 15 April 2013

[MS_AccessPros] Re: Path of back-end in Access 2007

Glenn,
There are several backends but the form is based on backend file "Usys_codeTCL". I want the path of this table to be displayed on the form. I tried to modify your code but it does not work.
Please help.

Kind Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" <argeedblu@...> wrote:
>
> If you have only a single backend then you can get the full path to the
> backend by looking it up in msysobjects:
>
>
>
> Dim strBEPath as string
>
>
>
> strBEPath =dlookup("database","msysobjects","database <> ''")
>
>
>
> Glenn
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
> Sent: Monday, April 15, 2013 8:26 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Path of back-end in Access 2007
>
>
>
>
>
> Glenn,
> Thanks but I want to get the backend path displayed in a form through a text
> box. How to do that in Access 2007?
>
> Kind Regards,
> Kumar Iyer
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
> <argeedblu@> wrote:
> >
> > Kumar,
> >
> >
> >
> > You can get the backend path from the table MsysObjects Database field.
> >
> >
> >
> > Glenn
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of access_kri
> > Sent: Monday, April 15, 2013 7:45 AM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Path of back-end in Access 2007
> >
> >
> >
> >
> >
> > Dear All,
> > I converted my Acess2000 database into Access 2007. I used to get the path
> > of back end displayed a textbox using in
> > txtPath=Mid([currentdb].[TableDefs]("Usys_CodeTCL").[Connect],11).
> However,
> > in Access 2007, the textbox is displaying #Name? error. How to get the
> path
> > in Access 2007?
> >
> > Thanks and Regards,
> > kumar
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>