Finding out Directory of Table

J

JavyD

Hello all,

I'm a bit new to access. I have a present database that I just maintain.
But I would like to find out what drives in my intranet the tables are coming
from, and perhaps on what other databases is that table utilized in, if this
is possible but no big deal if it cant be done
 
K

Ken Snell [MVP]

How can you possibly maintain a database without knowing the tables' file's
location? Assuming that they are linked tables, you can read the Connect
property of the table via DAO object library's functions.
 
J

JavyD

I think that the tables are generated by other queries in other databases.
It's like a table that seems linked from a drive. I told you I'm a bit new.
 
K

Ken Snell [MVP]

I'm sorry, but I'm not understanding what you have in your database.

When a query is displayed in datasheet view, it looks the same as a table
that has been opened in datasheet view. However, that query is not the same
as a table. Queries exist as SQL statements, not as tables.

You'll need to give us much more information about what you are seeing so
that we can try to give you an answer.
 
Top