By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,009 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

display pathname of linked mdb

P: n/a
Hi,

My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathname of
the data.mdb?

Thanks,

Susan
Sep 3 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Parse the path from:
CurrentDb.TableDefs("SomeLinkedTableNameHere").Con nect

If it helps, get the GetDataPath() function from here:
http://allenbrowne.com/ser-53.html#DataFile

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"susan" <vd*@hotmail.comwrote in message
news:a8**************************@cache5.tilbu1.nb .home.nl...
>
My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathname of
the data.mdb?
Sep 3 '08 #2

P: n/a
On Wed, 3 Sep 2008 14:18:24 +0200, "susan" <vd*@hotmail.comwrote:

Parse currentdb.TableDefs("SomeAttachedTable").Connect

-Tom.
Microsoft Access MVP

>Hi,

My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathname of
the data.mdb?

Thanks,

Susan
Sep 3 '08 #3

P: n/a
MsgBox CurrentProject.Connection.Execute("SELECT TOP 1 [DataBase] FROM
MSysOBjects WHERE Type = 6")(0)

On Sep 3, 8:18*am, "susan" <v...@hotmail.comwrote:
My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathname of
the data.mdb?
Sep 3 '08 #4

P: n/a
On Wed, 3 Sep 2008 15:03:26 -0700 (PDT), lyle fairfield
<ly************@gmail.comwrote:

But be aware that the MSys* tables are officially undocumented and
users are encouraged to use documented features.

-Tom.
Microsoft Access MVP
>MsgBox CurrentProject.Connection.Execute("SELECT TOP 1 [DataBase] FROM
MSysOBjects WHERE Type = 6")(0)

On Sep 3, 8:18*am, "susan" <v...@hotmail.comwrote:
>My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathname of
the data.mdb?
Sep 4 '08 #5

P: n/a
I appreciate Microsoft's position on undocumented features. They may
be removed or changed at any time. But I am a bit sceptical.

Are undocumented features so different from documented features? Do we
see, here in CDMA, almost every day, posts that describe upgrade woes,
outlining features that worked in a previous version but bring grief
in a newer version? I think we do. How many of these features are
undocumented? My recollection is, "None."

Can we name undocumented features that were present in Access 2000
which do not exist in Access 2007, or behave in a substantially
different way? I cannot. For instance, I have used the undocumented
property or function .Collect(Field-Index) which returns the value of
a record-set field more quickly than the "!" syntax or a .Value call
or a default property reference, thousands of times; to the best of my
knowledge this very useful feature works as expected in every version
of Access (more correctly I suppose in DAO and ADO). .Goto in place
of .SetFocus is another undocumented feature that can be found in my
code many times. It still works flawlessly. I can't remember why I
started to use this, but I think it was because it "Went-To" in some
circumstance where .SetFocus balked.

As for change we have only to look at the new Ribbon to decide, each
for himself or herself, if Microsoft has any commitment to making
change painless.

Does Microsoft encourage us to use Look-Up tables? Recordsets (when
SQL is an east alternative)? Yes?
Have a look at the SQL in Northwoods 2007! Is the inclusion of this in
Northwoods, encouragement?
Is what Microsoft encourages pertinent?

BTW, I am trying to write this in Google's new beta Chrome Browser.
It's very fast. It's spell checker may not be as helpful as some,
Safari's and Opera with GNU ASpell. It seems to take several seconds
to assess spelling and often there is no suggested alternative or a
very brief list.
On Sep 4, 1:08*am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 3 Sep 2008 15:03:26 -0700 (PDT), lyle fairfield

<lyle.fairfi...@gmail.comwrote:

But be aware that the MSys* tables are officially undocumented and
users are encouraged to use documented features.

-Tom.
Microsoft Access MVP
MsgBox CurrentProject.Connection.Execute("SELECT TOP 1 [DataBase] FROM
MSysOBjects WHERE Type = 6")(0)
On Sep 3, 8:18*am, "susan" <v...@hotmail.comwrote:
My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathnameof
the data.mdb?
Sep 4 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.