How to re-link tables to another B/E mdb with VBA? 1

[steve728]

Currently I have multiple in my Front-End.mdb linked
to MyBE1.mdb. I also have non-linked tables. I want to loop through all existing, linked only, tables and re-link them to another MyBE2.mdb container. Am I forced to drop the specific linked tables them link them to MyBE2.mdb? I want to do this all with VBA

I'm working with ADO, MS Access 2003.

Thanks,

Steve

 

[PHV]

Have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[steve728]

If just remembered that the current project I am working on is using ADO rather than ADO. If possible I would like to know how to acheive my objectives with both DAO and ADO.

Thanks in advance.

Steve728