source for the linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Open the table in design view and select Properties from the View menu.

Alternatively, in the VBA Immediate window type ...

? CurrentDb.TableDefs("YourTableNameHere").Connect
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Database file size and linked tables.... 4
Linked Excel spreadsheet to be used as table 3
Changing Links to access databases 1
linking tables and relationships 3
cannot link Foxpro file as table, access2000 3
access / excel link 4
Access 2007 ODBC Connection Failed 4

Back
Top