Control one access vb from another

[Timtropolis]

Control one access database from another

Greetings all!

I have a scenario where I need to have one Access db open another and do some editing. My question stems on which way to do this.

My initial thought was to Shell from the "Parent" database to the other, open a module in the child database and run the code. Problem with that is that I can't figure how to suspend the Parent database module code.

I would prefer to control the other database from Parent database module but am not sure on how to reference the child database.

I guess another question would be "Do I really need the other database to open to do any record editing or can I just remotely reference the "child" database?

If someone could point me in the right direction, possibly a sample, it would be greatly appreciated. I did look on here using key search words of controlling and automation but was unable to find what I needed.

TIA
Tim

 

[WayneRyan]

Tim,

The easiest way:

File --> Get External Information --> Link Tables

Then browse for the other database, select it, and establish a link to
its tables.

Logically, they will appear just like your local tables (except for ability
to change design).

Wayne