I am not sure of how to link tables in code. I found things about refresh link in the help file, but that seems to just be for what is currently linked. I need to actually switch the table links to an entire different database based on a form selection.
What I have is three back end mdb's. When the database opens I will have a form load asking to select which back end they want to connect to (production, development, or training). Once one is selected I will have it connect the linked tables to that database and open the switchboard. Does anyone have an easy solution to this or has done this and would email or post the code so I could get an idea of what to do?
What I have is three back end mdb's. When the database opens I will have a form load asking to select which back end they want to connect to (production, development, or training). Once one is selected I will have it connect the linked tables to that database and open the switchboard. Does anyone have an easy solution to this or has done this and would email or post the code so I could get an idea of what to do?