Backend path length

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have read somewhere that path length of the location of backend db effecta
the speed of the front end app. I have a very long path to the db on server
like this;

\\MyServer\Company Shared Folders\Company Main\DATABASES\MyDBData

Would it help if I share the above long path as \\MyServer\\MyDBData or does
the path on the server needs to be shortened?

Thanks

Regards
 
John said:
Hi

I have read somewhere that path length of the location of backend db effecta
the speed of the front end app. I have a very long path to the db on server
like this;
Click to expand...

Likely at Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
\\MyServer\Company Shared Folders\Company Main\DATABASES\MyDBData

Would it help if I share the above long path as \\MyServer\\MyDBData or does
the path on the server needs to be shortened?
Click to expand...

That's a good question. I would think that another share as you
suggest would be sufficient. Access wouldn't know anything about the
longer share.

You could also use utilities such as WireShark to examine the data
packets to see what happens.

Tony
 
Back
Top