M
mcp201
I wanted to find out how you know where an imported table/file in an Access
database comes from?
database comes from?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dirk Goldgar
mcp201 said:I wanted to find out how you know where an imported table/file in an Access
database comes from?
If you are talking about files or tables that have been imported into Access
tables, I don't believe there is any way. Files or tables that are linked,
not imported, have that information stored in the Connect property of the
DAO TableDef object that represents the linked table. In access 2002 (I
think) or later, hovering the mouse pointer over a linked table in the
database window displays a tooltip showing path to the linked file.
J
Jerry Whittle
Does the table name have anything to give you a hint? Or the data/fields in
the table?
Is the data imported by a function or macro?
the table?
Is the data imported by a function or macro?
J
John W. Vinson
I wanted to find out how you know where an imported table/file in an Access
database comes from?
Not unless that information was recorded somewhere at the time of import.
Access does not know or care.