Link access 2010 backend tables in a different directory
Posted on 2014-10-01
I am trying to develop code that will link to the backend tables in a subdirectory for an Access 2010 database. Problem is the various users have different mapping for their systems. However, they can all get to the directory, but on one machine the directory path is mapped with an X and on another it may be with a F. So, I have a local table in the front end database that only holds their directory path mapping, which they must enter either by typing or copy paste. Users are scatter around California. This is a low-usage database and they are not concerned about system slowness. I want a procedure that when they click "Link Tables", the code will use the path to locate the back end and link the tables. All the code I have found on the web requires the front and back ends to be in the same directory, but that is not possible in this case. Am looking for suggestions. I will do more searching, but hope for some help.