Creating a VBA code

[Esmatullaharifi]

I have built a database splitted to front end and back end but whenever I change the path of folder the front end is not opening because of path.


Question is here how I can create a VBA code that whenever the path error message displayed it runs and ask from user for the new location to connect to the back end database. Please help to solve this issue.
Thanks.

[June7]

Why are you changing path?

If this db will be located on a network server for multiple users, recommend UNC (Universal Naming Convention) pathing for the table links. Review:
http://forums.aspfree.com/microsoft-...tc-324677.html
http://forums.aspfree.com/microsoft-...ue-323364.html

[Missinglinq]

I also have to ask...WHY? Why are you changing paths often enough to warrant having a special procedure, in place, to enter the new one? After a dozen years of contributing, here and on half-a-dozen other Access forums, I can tell you that there are very few truly unique requirements out there, and I have never seen this one before. I'm not saying that you don't have a valid reason for needing this, just, as I said, really interested in knowing the why!

Linq ;0)>