Hi Y’all,
I’m having a bit of a problem with Access (2003) and VBA. I’d like to gain access to the TableDefs object in a linked database and can’t figure how to to it.
If I use CurrentDb.TableDefs(1).Name I get the name of the Linked table but
CurrentDb.TableDefs(1).DateCreated returns the current date (I relink the table everytime the db is opened {don’t ask}). If I open the .mdb file with the linked tables the same command returns the correct date. Likewise .RecordCount, .LastUpdated, .Updateable.
I can tell if the table is linked by use of the .Connect property which returns a connection string, I think, i.e., ;Database=G:pathfilename.ext or blank if the table is not linked. But how do I directly access the linked DB file to get the values I need? :cheers: