Question Custom Error Message on Link Tables

[Access2007User]

Good day!

I have a frontend and backend linked.

When my access application opens, it says error message that the path of the database file was not found. this is because I have moved my database to other location.

How can I make a custom error message for that?

 

[namliam]

Use the DIR function to check if the Backend is there on the proper location...
If not pop a custom warning message and close the database.

You can find the code I use to relink my table here

Good luck !

 

[Access2007User]

thanks for the reply but when is the proper time to make the code work? Is it on form open event?