Hey all,
I have a situation and I wanted the expertise of the great minds on this group. We currently have a VB6 application that runs on a MS Access 2003 backend that we use for inventory and repair order management. It was an application I developed in-house. We now ready to move the application over to the VB.NET platform with a SQL Server backend and increase the functionality of the application. I am mulling over two different ways to do this:

1. Move the app to VB.NET and leave on MS Access but upgrade to MS Access 2010 and then increase the functionality. Once this is all tested and stable, go back and migrate to SQL Server.
2. Move the app to VB.NET and migrate to SQL Server and then increase the functionality.

I am thinking option 1 is where I want to go because to move from VB6 to VB.Net will probably require a good bit of rewrite for the software at which time I can just increase the functionality along with the rewrite. I want to get that stable so that the personnel at the company can move to this new version and use it because they do need to get the inventory completed by the end of January. Once the inventory is completed, we can then work on the migration to SQL Server which will also require some rewrite for the queries and database setup. My thought is moving it to another Access database would reduce some of the time to get it back up and running so we can use it.

Please let me know your thoughts on this.
Thanks
Kim