Linked tables: Long file path

[DT]

Hello all,

I am experiencing quite a strange phenomenon with mu Access 2000 db. I am
using linked tables to link to a backend Access 2000 mdb. I recently moved
the file to a file path which has over 120 characters and have found some
strange problems. For instance, I am unable to open the table for viewing.
When I select open I see the hourglass for a fraction of a second and then
nothing happens. If I try to access the tables in a form I get exception.
The compact and repair also fails mid way. When I place the exact same files
in another directory which is not so nested, everything works fine.
thank,

DT

[Allen Browne]

Longer paths for attached tables - yes it's known to be a performance issue.

From memory, it's one of the issues Tony Toews has listed on his performance
page at:
http://www.granite.ab.ca/accsmstr.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DT" <de******@dtrombi.com> wrote in message
news:n%*****************@nnrp1.ozemail.com.au...

Hello all,

I am experiencing quite a strange phenomenon with mu Access 2000 db. I am
using linked tables to link to a backend Access 2000 mdb. I recently moved
the file to a file path which has over 120 characters and have found some
strange problems. For instance, I am unable to open the table for viewing.
When I select open I see the hourglass for a fraction of a second and then
nothing happens. If I try to access the tables in a form I get exception.
The compact and repair also fails mid way. When I place the exact same files in another directory which is not so nested, everything works fine.
thank,

DT