searched and searched, and found lots relating to EXCEL, but nothing to ACCESS
is it possible to retrieve the value from a single field in the only record in a table when the mdb file is closed and currently un-linked ?
if I link the table (as a back-end) to get that value, I can't update (ADD/MOD/DEL) fields to the table (while it is linked); even if i subsequently break the links, best that i can tell is that access still thinks the file is open, and if it is open, I also cannot make the update.
I'm trying to retrieve a value in that file's table tblSYS which is the date of that file's last update (to determine if it is up-to-date...)
m.