How do I point form to table in another *.mdb file?

[RoyKMathur]

I have separated my application logic (forms, VBA code, queries) from my data and am unable to open my form. The form is in file DbAppl.mdb and the table is in file DbData.mdb. Any ideas? Thanks.

 

[RuralGuy]

Use the Linked Table Manager: Tools>Database Utilities>Linked Table Manager

 

[RoyKMathur]

Ah, I see. Yes that is a way to do it. The problem is that it means hard-coding the link. I need to be able to dynamically create the link because I actually have multiple data.mdb files depending on the development environment that's being used. So what I need is a VB code solution.

 

[RuralGuy]

Here's one possible solution: Reconnect Attached tables on Start-up

 

[RoyKMathur]

Thanks, I'll give it a whirl.