Backend path length

[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

 

[Tony Toews [MVP]]

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;

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?

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