Thank you Wendell and William for valuable inputs..

Even before conversion I made the application split, each of our users have Accde file on thier desktops.

I will first convert the master query to a view in SQL and have that linked with MS Access.

Thanks again, I will reply back on the results..