AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
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.
