As to migrating to SQL server. You can use an ADP to directly connect to your SQL Server. An ADP is like an MDB only it does NOT use the JET DB it uses SQL Server.

You will have to change the forms to some degree. Since you are in the DEV mode you can port the Access tables to an instance of SQL server into a temporary DB and then DEV you forms using an ADP. You can still make an executable version of the ADM but it is called an...