Migrating user share – how to handel mdb files with link old server

Hi everyone,

We are planning to transfer the personal user shares data to a new server. This new server has also a new name. But the drive letter stays the same

My question is can you advise me on wat will happen when a user has an excel or access database who links to the old server?

And is there a way to resolve this without interfering the users?

Thank you for your help!