This product sounds pretty cool.  The one thing I caution is that many Access applications are designed poorly and porting them to SQL Server as is will not solve any problems.  In fact, it might make things worse.

Steve, you are smart to recognize that the existing application has desgin flaws and are willing to address those before moving to SQL Server.