Link 3 specific tables in VB

[Guest]

I have a split 2003 access db. The back end holds approx 50 tables.
3 of the tables (call them a,b & c) hold no data. I have another db
containing just 3 tables (a,b & c) and these tables hold the data. I have
these tables in a different db as they contain pricing information which
changes on a weekly basis. The list is also growing weekly.
I would like to have a command button to link just these 3 tables using VB,
asking the user which db they wanted to link to.
I have looked at the code written by Dev Ashish and also by Timothy Pascoe
and Lyle Fairfield but all appear to be doing much more than I need.
The table names will always be the same its only the path and db name which
will change and this will be selected by the user.
Any ideas? Does this make sense?
Thank you.

 

[strive4peace]

Hi Simon,

I have a sample database with one table (lists tablenames to link to),
one form (so you can Browse for the back-end and link specified tables)
and 2 modules -- one that I wrote and one written by Ken Getz for the
File Open dialog box. I will send it to you if you email me. Be sure
to put TableLink.mdb in the subject so I know what to send

You will need to import these 4 objects into your working database and
edit the Syslinks table to list the 3 tablenames you want to link to.
Then, you can just use the form provided...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*