Network DB

[MBA80]

I just finished my first (very simple) DB. I now need to drop it on to a network location for around 50 people to have access to. I have already done the DB split to keep the table information safe, and then created the ACCDE file which only had the forms visible for the end users.



It all works properly from my computer (using the file the network) but when I had a co worker try to use the ACCDE file, they were able to copy it to their desktop, and open the file but could not open the form. The issue is when they try to open the form for the end users they generate an error: '<file location> is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides.'

Everyone has access to this shared folder location as we have another shared DB out there as well. I don't want to have to have everyone map the shared drive to their computers permanently (they didn't have to for the other DB).

The issue I see in the error is that it is trying to look for the "x" drive, which is how I have the drive mapped on my own computer. I need the form to look for the IP address of the shared folder location rather than my drive letter. Where do I make that change in the DB?

[RuralGuy]

You should have used the Linked Table Manager to link up the BackEnd tables. It would then be using the UNC name instead of a drive and path.