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 MVPCommented:
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
 
als315Commented:
You can use Jstreet Access relinker:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
updated version:
#a38653506
0
 
pdebaetsCommented:
Our free TableLinker utility may help: http://www.peterssoftware.com/tlk.htm
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.