UNC connection to db backend?

[jbehrne]

Hi all,

I am going to split an Access 2002 database frontend and backend. I don't want to use a mapped drive connection for the location of the backend and I'm looking at a UNC connection. Any pros/cons for using this as opposed to a mapped drive connection?

Thanks,

jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[jsteph]

Security might be an issue--if you map a drive under, say, a different username, then you have that user's rights to that drive/folder's files. If you use a unc, then it's your logon under which the permissions are set.
-Jim