Yes thats the idea making your accessdb as a frontend and you will be linking table from sql server into MS Access.

All you need to do coding using DAO recordset and it's method. Feel free to post if you get stuck somewhere or if

you need code help. Please post your notes with sufficient details.