Expert: Scottgem - 2/11/2005

Question
What happened?

I split my database and I asked that the backend be stored on the server.  The Frontend is in a separate file.

I never had a problem at the computer that I worked at, but when I went to access the file on the other computers, it would not load because the reference went constantly to the backend and forms would not open.  I even loaded another computer with the file on my hard drive and when I went to open it, it continued to reference the backend file.  What am I doing wrong?

Any thoughts

Answer
I suspect its a mapping issue. On your PC, the server may be an F Drive, on another it may be G. The way to check is to go to Tools>Database>Linked Table Mgr and see what the path is.

The solution to this problem is to use UNC coding instead of a mapped drive. UNC takes the format of:

\\Servername\Sharename\Foldername\Filename

What you can do is select all the links, check the box to prompt for new location, then navigate to the backend using Network Places or Network Neighborhood (depending on your version of Windows). Use entire network, find the server, and then navigate to the folder to select the back end file. You will then need to copy the front end to the other local computers. With UNC drive mappings don't matter since the server is addressed by name.

HTH
Scott<>