are these existing Access dbs that you want to upgrade to SQL?
you say you have six weeks experience in MS Access...what SQL experience?
ever designed a front end app before?
I have no SQL experience and am trying to learn on the fly... With the mentione of lockups in SQL my concern would be multiple users trying to access the front end and getting locked up. Would that be common with using SQL server as the back end and Access at the front end app?