Relink Access tables from code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

noodleBrain - 21 Jul 2006 02:57 GMT

My mdb fe links to multiple back end mdb files - the recommended code from
The Access Web works but only lets me select one location and then tells me
a particular table (from a different back end) doesnt exist. How can I
select multiple back ends one after the other (if that makes sense).

I used the code from http://www.mvps.org/access/tables/tbl0009.htm to open
the SaveOpen Dialogue to relink table at db start up (calling function with
Macro).

Cheers,

nB

Reply to this Message

Larry Linson - 21 Jul 2006 03:32 GMT

> My mdb fe links to multiple back end mdb
> files - the recommended code from The
[quoted text clipped - 9 lines]
> db start up (calling function with
> Macro).

Your code will have to be sufficiently smart to know which tables are from
the same source database, and do the same functions as that code does, for
each of the separate sources: let the user use the dialog and select the
database, and then reset the .Connect property of the pertinent tables, and
.RefreshLink for each.

I gather from your question that you may not be conversant with the VBA
code, so were hoping just to use the sample code unaltered without having to
understand it. If that is the case, you may want to hire an Access developer
for this part of your project.

Larry Linson
Microsoft Access MVP

Reply to this Message

Andy - 21 Jul 2006 20:57 GMT

> My mdb fe links to multiple back end mdb files - the recommended code from
> The Access Web works but only lets me select one location and then tells me
[quoted text clipped - 8 lines]
>
> nB

I have some code to do this. I will send it to you if you like. It was
originally written in A97, but has been tested in A2k and A2003.

The code allows you to link different tables to mulitple backend
databases. It is form driven. All you need to do is modify one table
containing the database locations and tables to be linked.

Send me an email if you want it.

Andy

Reply to this Message

noodleBrain - 23 Jul 2006 10:26 GMT

thanks Andy that would be great - kewelmagic@hotmail.com

> > My mdb fe links to multiple back end mdb files - the recommended code from
> > The Access Web works but only lets me select one location and then tells me
[quoted text clipped - 18 lines]
>
> Andy

Reply to this Message