OK, I asked a friend of mine on the Windows team to look at this problem,
and
she noticed I had some "problem" characters in the name of the file. She
recommended I remove them ( "-" and 2 extra "."), so now the file name
just
had letters and numbers with a .mdb at the end.
She couldn't offer an explanation as to why it didn't work on a network
share but would on my own disk, since I'm using the same driver. But she
noted she had seen other people with similar problems, and used a similar
solution.
At any rate, that part of the problem is fixed.
Bob
"INTP56" wrote:
> 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
|
