source for the linked table

I inherited an Access 97 database from one of my co-worker who is no longer
with the company. The issue is there is a linked table to an EXCEL
spreadsheet in this database and I can't figure out where the EXCEL
spreadsheet is located. In other words, I would like to know the source for
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6869-source-for-the-linked-table.html
te lined table. Can somebody help me on this?

Kanan

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Open the table in design view and select Properties from the View menu.

Alternatively, in the VBA Immediate window type ...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6869
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6869

? CurrentDb.TableDefs("YourTableNameHere").Connect

--
Brendan Reynolds


"Kanan" wrote in message
news:036D961C-C536-4822-9189-A88F635551B4@microsoft.com...
>I inherited an Access 97 database from one of my co-worker who is no longer
> with the company. The issue is there is a linked table to an EXCEL
> spreadsheet in this database and I can't figure out where the EXCEL
> spreadsheet is located. In other words, I would like to know the source
> for
> te lined table. Can somebody help me on this?
>
> Kanan