This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a database that is being used in the following manner:
Here's the problem I've seemed to run into. The front end database has been in use for many months now. Apparently it stopped working for some users. I gave them a fresh copy of the front end that I refreshed the links on and it's working fine for them. I would like to know if there is a way that I can toss a macro or some VB code into the front end that will refresh the links when opened. Please note when I say VB code I'm not the best at this. Last VB class taken was 10+ years ago.
Thank you,
Robert
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
You should link with UNC path. There have been reports about mapped drives getting disconnected (by design).
They were getting the generic path not found error. Nothing at all moved on this. Any ideas?
"it stopped working for some users"
In what sense? What error did they get?
Unless the location of the BE changed, relinking should do nothing. Your issue is elsewhere I suspect, but we'd need more information.
Hi Robert,
I agree with Tom. Giving the users a fresh copy of the FE is a simple solution and will work 100% of the time. However, if you would like to pursue a VBA code solution in the future, you might consider trying JStreet's Access Relinker.
Just my 2 cents...
If the BE location has not changed, there is no need for reattach code. Relinking tables in code to the same BE is a no-op. The application could have stopped working for any number of reasons. Much simpler to refresh the FE and they're on their way again.