Mohsin Malik
Registered User.
- Local time
- Today, 06:16
- Joined
- Mar 25, 2012
- Messages
- 175
Hello All,
I have a question that I have a Microsoft Access database (.accdb) front-end/backend split and I want to give the database to my company client. As we have the different path for the backend/frontend linked. I want some code that will popup if the database location is not found and popup with the dialog so the user then select the backend and it would be ready and there is no need to popup each time the database open, it would run once it did not find the last linked path.
Also I have tried the code of Dev Ashishhttp://access.mvps.org/access/tables/tbl0009.htm but unfortunately it would ask everytime to refresh the table links and I only want to run the process of linking tables when the database start and the linked path not found, I hope if anyone can help me quick.
Thank you
Mohsin
I have a question that I have a Microsoft Access database (.accdb) front-end/backend split and I want to give the database to my company client. As we have the different path for the backend/frontend linked. I want some code that will popup if the database location is not found and popup with the dialog so the user then select the backend and it would be ready and there is no need to popup each time the database open, it would run once it did not find the last linked path.
Also I have tried the code of Dev Ashishhttp://access.mvps.org/access/tables/tbl0009.htm but unfortunately it would ask everytime to refresh the table links and I only want to run the process of linking tables when the database start and the linked path not found, I hope if anyone can help me quick.
Thank you
Mohsin