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

Locating Source Locations For Linked Tables In Access?

P: n/a
Hi Access masters,

Sorry for asking a very simple question, but how
could I locate source tables which have been linked
into the Access database? The following is an ASCII-
based screen shot:

| +===============================================
| | db1: Database
| +-----------------------------------------------
| | Table | Query | Form | Report | Macro | Module
| + +---------------------------------------
| | -> Customer <--These tables are link
| | -> Dealer <--tables. How could I locate
| | -> Contract <--there source locations?
| | Sales
| | product
| | etc.
| |
| +===============================================

I'm at work right now and have no access to my library
at home. Any information is highly appreciated.

Thanks in advance,

alea
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Examine the Connect property of the TableDef.

In the Immediate Windows (Ctrl+G), enter:
? dbEngine(0)(0).TableDefs("Customer").Connect

You can also set the Connect property to reassign the source to a different
folder, but remember to RefreshLink

--
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.

"aleatory" <al******@hotmail.com> wrote in message
news:a6**************************@posting.google.c om...
Hi Access masters,

Sorry for asking a very simple question, but how
could I locate source tables which have been linked
into the Access database? The following is an ASCII-
based screen shot:

| +===============================================
| | db1: Database
| +-----------------------------------------------
| | Table | Query | Form | Report | Macro | Module
| + +---------------------------------------
| | -> Customer <--These tables are link
| | -> Dealer <--tables. How could I locate
| | -> Contract <--there source locations?
| | Sales
| | product
| | etc.
| |
| +===============================================

I'm at work right now and have no access to my library
at home. Any information is highly appreciated.

Thanks in advance,

alea

Nov 12 '05 #2

P: n/a
Hi Allen,

Thanks for your quick reply on my question.

Indeed one of the tables was linked to another table
through the network. Without checking this stuff out,
it could have been a disaster before actually doing
anything to the database.

Whew, I was luck to have your advice; otherwise, I
could have been forced to update the database without
knowing the source tables!

Thanks again,

alea
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...
Examine the Connect property of the TableDef.

In the Immediate Windows (Ctrl+G), enter:
? dbEngine(0)(0).TableDefs("Customer").Connect

You can also set the Connect property to reassign the source to a different
folder, but remember to RefreshLink

--
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.

"aleatory" <al******@hotmail.com> wrote in message
news:a6**************************@posting.google.c om...
Hi Access masters,

Sorry for asking a very simple question, but how
could I locate source tables which have been linked
into the Access database? The following is an ASCII-
based screen shot:

| +===============================================
| | db1: Database
| +-----------------------------------------------
| | Table | Query | Form | Report | Macro | Module
| + +---------------------------------------
| | -> Customer <--These tables are link
| | -> Dealer <--tables. How could I locate
| | -> Contract <--there source locations?
| | Sales
| | product
| | etc.
| |
| +===============================================

I'm at work right now and have no access to my library
at home. Any information is highly appreciated.

Thanks in advance,

alea

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.