By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Linked tables: Long file path

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.