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?
minimal Access experience / No SQL experience and I am going to assume no app dev skills either...correct?
you talk about existing databases...what platform are these currently on...who currently manages them...could those people assist you?
if your app is mainly read only / reports then I wouldn't get too hung up about "locks"...
if it going to be mainly data entry (create/amend/delete) then you will need a reasonable level of experience in any front end on how you intend the app to manage situations where possible locking may occur...and manage it gracefully so that the user understands what is happening.
Todd...I do not wish to dissuade you from your pursuit...only to point out that there is no easy way and a steep learning curve ahead;..whatever your preferred option.
________________________________________________________________you can lead a user to data....but you cannot make them think
and remember....every day is a school day