asked on

MS ACCESS 2010 - ? dynamically link external tables ?

I'd like to be able do dynamically link to external tables in MS ACCESS 2010.

Consider a file structure like:

C:\myApp\Programs\myprogram.accdb
C:\myApp\Input\inputfile1.ACCDB
C:\myApp\Input\inputfile2.ACCDB
...
C:\myApp\Input\inputfileNN.ACCDB

I'd like to be able to start myprogram.accdb and have an autoexec run some VB code to find all NN of the files in the INPUT folder
and dynamically link to them.

I want to be able to move the ENTIRE myApp folder to a new location and have it run there with no changes.

Thanks
Phil

ASKER CERTIFIED SOLUTION

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

als315

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

pdebaets

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

philkryder

ASKER

no source code - just executable

als315

Jstreet relinker has source codes.

philkryder

ASKER

Thanks everyone!
I ended up building a VB launcher that finds the Newest FrontEnd program, copies it to Local profile, and then launches it with a /CMD parm that points to the location of the backend database files. The front end then relinks all linked tables based on the parm.

Thanks much! Phil

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

Phil,

Thanks for the update and your solution.