using UNC path for linked tables

[tagteam]

I have a database that i use on Terminal Server. Each user has their own front end copy on terminal server that is linked to a single backend. Some parts of the app require using Outlook to email things and this works much better when it is opened from the local machine. To do this I create another front end that the user opens over the network ( not using terminal server)

is it a problem to have all the databases use the UNC path instead of linking to the local drive.

So for example the TS clients currently like to the back end on the e drive. this would link them to the back end via \\servername\filename.

Would this cause things to slow down for the regular users?

[redbull]

Nope. To the system there is no speed difference, the reason people use the UNC path over the drive letter is because the drive letter can be assigned differently for different people.

I'm sure someone else will either myth busted/confirm my post.

[tagteam]

Do you see any problem with mixing UNC and drive letter? I have a front end that links to a backend database with several tables. I also want to link to a few other tables in a different back end database but I dont really want that one shared out on the network. So i mapped the database in the shared drive to UNC path and mapped the database in the non shared drive to drive letter.

Is that a bad practice or fine?

[ssanfu]

To do this I create another front end that the user opens over the network ( not using terminal server)

If you mean connecting a FE to a BE across a WAN (not TS), this a know cause of corruption.
You should read the following:

Using a wan with ms-access?
http://www.kallal.ca/Wan/Wans.html

[tagteam]

No, I am using UNC and Drive letter on the same server. The users at the remote location use Terminal server so in the end all the remote work is actually done locally on the server.

Some users that are in the same physical location as the terminal server connect with a front end on their local machine or over the network share.