Although, I do not have extensive experience converting MS Access to SQL and I'm sure there are many issues involved that I have no understanding or knowledge of, I have converted tables to SQL and linked them to my MS Access application - as I would any other external database that Access is compatible with and I have had no problems using my existing forms, queries, reports and/or modules.
The user asked if there was an easy way to convert his access db to SQL. In my experience, if my database forms, queries, reports and modules work in MS Access format -before I upsize, I see no reason why it shouldn't work in the same manner after I've upsized my tables and linked them to my Access application. Based on this, I responded to the question and I still stand by my statement.
Are there acceptions? Most likely.
Should I have responded that you have to be careful, not everything will work the same after upsizing? It's not my experience, so.. no, I don't think I should have said that.