Finding out Directory of Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JavyD - 06 Jan 2005 21:55 GMT

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

Reply to this Message

Ken Snell [MVP] - 06 Jan 2005 22:00 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> Hello all,
>
[quoted text clipped - 4 lines]
> this
> is possible but no big deal if it cant be done

Reply to this Message

JavyD - 06 Jan 2005 22:15 GMT

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.

> 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

Reply to this Message

Ken Snell [MVP] - 07 Jan 2005 01:57 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

>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
[quoted text clipped - 8 lines]
>> this
>> is possible but no big deal if it cant be done

Reply to this Message