Thanks all, appreciate your replies!

I was quite lost. I could see incoming calls to SQL from host A supposedly via the access db. However, having spent hours on it, I found an additional mde file that had linked tables connecting via a dsn.

I'm hoping I only need to amend the dsn. I will find out!

Thank you all.