Table linked or not ?

[Gerry Abbott]

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: [phone]
Fax:[phone]
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

[Allen Browne]

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?

[Peter Doering]

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.

[Gerry Abbott]

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: [phone]
Fax:[phone]
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