You have a split database, end users can’t access the database because you’re getting an error message saying Microsoft can’t find the back-end file even though you know it’s in the folder it’s listing! Besides making sure the end users have the proper permissions to the folders, the problem could be that the users do not have consistent drive mappings. Here’s a step-by-step solution to try.
- Click the “External Data” tab.
- Click the “Linked Table Manager”.
- Make sure the “Always prompt for new location” is checked.
- Check the boxes next to your table it can’t locate and click OK.
- In the “File Name” area, type \\YOURSERVERNAME\YOURFILEPATHTOYOURDATABASEFILE
- Click “Open”.
- Click OK.
- Save and make sure to save this to your front-end (user) database.
Typing your actual server name instead of a file path letter allows any users computer to understand the file path.
By Rana Kory