Hello, all,

Wondering if there is a way to do this...
I have a front end user application in Access and two back ends. The two backends are identical. The difference between the two back ends are that one is for development and the other is live (users hit this via the front end). Normally the front end is linked to the live back end. There are times when I need to do developmental work and I want to hit the developmental back end for testing.

Normally, I can use the linked table manager to relink my front end to the developmental back end. There are alot of linked tables so this becomes a time consuming process to relink the tables every time.

I was wondering if there is a way to do this via code? Then all I'd have to do is hit a button and it would link me to the developmental back end or the live back end.

Thanks in advance!

Strick