Access 2000 front end MDE back end mdb - if the database is installed to another directory other than the one where the front and back end were originally linked you get an error when you try to open the front end. Is it possible to have the mde look in the same folder as its self rather than what was linked in the link table manger?
I would like to reproduce the link table manager via a button in the database ie "Change data file location" so that when a user clicks on it they browse to the new data location and action the linked table manager. could someone please provide the code that would sit behind such a button.
Also would it be possible to get this to run if the front end cant find the back end ie where would you put the code for that and what would it be?