Best way to point to different linked tables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurel - 26 Jan 2005 15:42 GMT

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

Reply to this Message

Ken Snell [MVP] - 26 Jan 2005 17:01 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

>I have an application with a separate backend database. As one would
> predict, I would very much like the application to run against different
[quoted text clipped - 3 lines]
> Thanks,
> Laurel

Reply to this Message

Laurel - 26 Jan 2005 18:00 GMT

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

> Not sure what the question really is. Use Linked Table Manager to link the
> tables from the different backends as needed.
[quoted text clipped - 10 lines]
> > Thanks,
> > Laurel

Reply to this Message