I'm not sure this is the right place, but I'm getting desparate.
I have an Access 97 database. When I copy it to My Do***ents, I can go
into
Excel 2003 Data > Im****t External Data > New Database Query ..., and
select
data out of the file.
However, if the file resides on my P drive (Networked files server) I get
a
message
No Visible tables.
I copied it over to another server where I have access, same thing. I
copied
it over to another server where I am a sys admin, same thing.
It would seem there is something about being on a network drive that
prevents me from seeing any tables in the MDB file.
I can not move the file to a local drive as a long term solution. Can
anyone
give me any insight as to what is happening here?
TIA, Bob
|
