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
LVL 1
philkryderAsked:
Who is Participating?
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
Sure you can do what you want.

Herre is some code that will work: Link Tables: Re-Linking back-end (BE) database

also see: DB start up and BE relinking
0
 
als315Connect With a Mentor Commented:
You can use Jstreet Access relinker:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
updated version:
#a38653506
0
 
pdebaetsConnect With a Mentor Commented:
Our free TableLinker utility may help: http://www.peterssoftware.com/tlk.htm
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
philkryderAuthor Commented:
no source code - just executable
0
 
als315Commented:
Jstreet relinker has source codes.
0
 
philkryderAuthor Commented:
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
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Phil,

Thanks for the update and your solution.
0
All Courses

From novice to tech pro — start learning today.