Back End and Front End

[prmitchell]

Hi
I have a database system into the back end and front end and then created the accde file with the front end file to give this to users on their computer. The back end being placed on a server with a path of type \\servername\folder

I have used the Linked Table Manager to point to the tables
\\servername\folder\filename.accdb

but in doing this I get a message Windows cannot access \\servername\folder

is this to do Network Rights on the server that I don't have permission to access the server and folder - and if so, how does grant this
or
is this something to do with what I am doing in Linked Table Manager.

Help much appreciated.

Peter

 

[MarkK]

I would map a virtual drive on the users machine and link tables to that drive. Google 'create network share mapped drive windows', or something like that. That'll be faster and more reliable.

 

[DavidAtWork]

It is possible to write some startup code that will map the user's machine to the server, effectively creating a virtual drive as lagbolt suggests, and then relinks all the tables. You could also have it so it disconnects the drive when the database closes.
David

 

[Pat Hartman]

lagbolt, Using the UNC is a better technique than a mapped drive because in many environments, it is impossible to find a common unused drive letter so the UNC is the only way to link to the correct server.

If you need help with granting permissions, this is the wrong forum to ask. You may get an answer but folks here develop software. They don't usually do desktop support. You need someone who can walk you through this for your specific version of Windows. If you want to post your version of windows and the version on the server, perhaps someone would be able to show you screen shots.