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

Table linked or not ?

P: n/a
Hi all,
Could someone tell me how I can tell (in code) if a table in the current db
is a linked one or not?

Thanks,

Gerry
Mitas
Ryemont Abbey,
Leixlip,
Co. Kildare
Phone: 01 6104509
Fax:01 601 4716
In**@mitas.ie
www.mitas.ie
_______________

DISCLAIMER:
This e-mail may contain proprietary information,
and is covered by copyright. It may be legally privileged, and is for the
intended
recipient only. If you are not the intended recipient you must not use,
disclose, distribute, copy, print or rely on this e-mail.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/03
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
A linked table has information about what it is linked to in the Connect
property of the TableDef.

Test:
Len(dbEngine(0)(0).TableDefs("MyTable").Connect)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:F6*******************@news.indigo.ie...
Could someone tell me how I can tell (in code) if a table in the current db is a linked one or not?

Nov 12 '05 #2

P: n/a
Gerry,
Could someone tell me how I can tell (in code) if a table in the current db
is a linked one or not?


<F1>Connect Property

Example:

If CurrentDB.TableDefs("YourTable").Connect = "" Then
MsgBox "This is a local table"
Else
MsgBox "Linked table. Connect= " & _
CurrentDB.TableDefs("YourTable").Connect
EndIf

HTH - Peter

--
No mails please.
Nov 12 '05 #3

P: n/a
Thanks, Just what i was looking for.
"Gerry Abbott" <pl****@ask.ie> wrote in message
news:F6*******************@news.indigo.ie...
Hi all,
Could someone tell me how I can tell (in code) if a table in the current db is a linked one or not?

Thanks,

Gerry
Mitas
Ryemont Abbey,
Leixlip,
Co. Kildare
Phone: 01 6104509
Fax:01 601 4716
In**@mitas.ie
www.mitas.ie
_______________

DISCLAIMER:
This e-mail may contain proprietary information,
and is covered by copyright. It may be legally privileged, and is for the
intended
recipient only. If you are not the intended recipient you must not use,
disclose, distribute, copy, print or rely on this e-mail.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/03

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/03
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.