Reattaching MS Access tables after moving to DASP

[Scott]

Consider this scenario: main.mdb, a.mdb, and b.mdb are MS Access databases which reside in the same directory. The a.mdb and b.mdb databases both link to a table in main.mdb.

When the databases are moved to the DASP server, the links are "broken" because the directory path that was stored for the link when it was created on the local host does not exist on the DASP servers.

Is there a way to recreate the links once the databases are moved to the server? Can anyone point me in the right direction?

Thanks,
Scott

[bruce]

i think you'll have to recreate the link

[b]quote:Originally posted by Scott

Consider this scenario: main.mdb, a.mdb, and b.mdb are MS Access databases which reside in the same directory. The a.mdb and b.mdb databases both link to a table in main.mdb.

When the databases are moved to the DASP server, the links are "broken" because the directory path that was stored for the link when it was created on the local host does not exist on the DASP servers.

Is there a way to recreate the links once the databases are moved to the server? Can anyone point me in the right direction?

Thanks,
Scott

</blockquote id="quote"></font id="quote">

[Scott]

Yes, I agree. I do have to recreate the link(s). <u>My question is how?</u> I was unable to find an answer in Access help, on MSDN, in the knowledge base, or by Googling.

Scott

[quote]Originally posted by bruce

i think you'll have to recreate the link