Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

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
0
philkryder
Asked:
philkryder
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now