I am preparing a database for run-time distribution on several PCs on a network that has no Access. I’d like to put the front end on the local PCs, linking to a back end on the X: drive on the server. Not rocket science.
However, I’m developing on a standalone PC, and don’t have an X: drive on my PC. I can’t re-link the table after putting the run-time version on the client’s PC, but don’t seem to be able to change the link on my development PC to dummy up the path to the X: drive before deployment.
Perhaps it’s obvious that I shouldn’t be able to do this, but what do developers do when they’re preparing databases for deployment on networks with different drive mapping from their development systems?
I’m competent with VBA, so will resort to code if there isn’t a more obvious solution. Am I missing something, or expecting too much?