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

Senin, 15 April 2013

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

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]