Linked Table Attributes

G

Guest

Is there a way to find out the date a linked table was last updated, other
than .lastupdated which doesnt seem to work for me?

I have a series of linked tables to worksheets in an excel file. I update
these worksheets periodically, and never at the same time. I would like to
create a field in a summary table (of all the linked tables) in which the
date the worksheet was last updated. I tried using the command above, but it
only returns the date I linked the table to access.

Please help

Thanks,
 
D

Douglas J. Steele

I don't believe Access can give you that information.

It might be possible to read the workbook, using Automation, but it
certainly isn't going to be a property of the linked table.
 
G

Guest

Oh well, thanks anyways...

Douglas J. Steele said:
I don't believe Access can give you that information.

It might be possible to read the workbook, using Automation, but it
certainly isn't going to be a property of the linked table.
Click to expand...
 

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

VB Code to copy linked table to local 4
How to connect to a BE database? 0
Check if a linked table in the database has been updated/changed 1
Cannot update linked Paradox table field with DAO recordset? 4
check if a table is linked 2
Cannot find a linked table 2
Access Form Refresh 1
Copy table to different database 5

Top