Best way to point to different linked tables?

[Laurel]

I have an application with a separate backend database. As one would
predict, I would very much like the application to run against different
databases with different names and locations. I'd appreciate suggestions
about ways to accomplish this.

Thanks,
Laurel

 

[Ken Snell [MVP]]

Not sure what the question really is. Use Linked Table Manager to link the
tables from the different backends as needed.

If you want to do it via code when the database opens, then see this article
at The ACCESS Web for a starting point:
http://www.mvps.org/access/tables/tbl0009.htm

 

[Laurel]

Thanks, yes, the article is what I needed. I want the same application to
be abe to link to different tables at runtime.