Does anyone have suggestions as to how to approach the conversion of a project that has MS Access 2003 as the Front End and SQL Server 2005 for the back end into an ASP.NET 3.5 project that uses MS Access 2003 to ASP.NET 3.5? The project has in the neighborhood
of 85 Forms/SubForms, 215 MS Access Queries that have not been converted, and about 100 MS Access Reports that need to be converted.
I have seen some conversion software websites, but none of them have enough information
Roll your sleeves up. Access forms and ASP.NET web forms have next to nothing in common. Most of the conversion tools were written pre ASP.NET 2.0, so they are virtually useless now (and were probably useless to start with).
If this is a Line Of Business, mainly CRUD system, you might want to look at using Dynamic Data:
http://www.asp.net/dynamicdata. It includes a lot of scaffolding which means forms can be auto-generated relatively easily. If you want to maintain a desktop like interface with subforms in tabs etc, you will want
to learn AJAX as well.
ASP.Net_Rook...
None
0 Points
3 Posts
MS Access 2003 to ASP.NET 3.5
Feb 01, 2011 06:36 PM|LINK
Does anyone have suggestions as to how to approach the conversion of a project that has MS Access 2003 as the Front End and SQL Server 2005 for the back end into an ASP.NET 3.5 project that uses MS Access 2003 to ASP.NET 3.5? The project has in the neighborhood of 85 Forms/SubForms, 215 MS Access Queries that have not been converted, and about 100 MS Access Reports that need to be converted.
I have seen some conversion software websites, but none of them have enough information
Mikesdotnett...
All-Star
154830 Points
19854 Posts
Moderator
MVP
Re: MS Access 2003 to ASP.NET 3.5
Feb 01, 2011 10:12 PM|LINK
Roll your sleeves up. Access forms and ASP.NET web forms have next to nothing in common. Most of the conversion tools were written pre ASP.NET 2.0, so they are virtually useless now (and were probably useless to start with).
If this is a Line Of Business, mainly CRUD system, you might want to look at using Dynamic Data: http://www.asp.net/dynamicdata. It includes a lot of scaffolding which means forms can be auto-generated relatively easily. If you want to maintain a desktop like interface with subforms in tabs etc, you will want to learn AJAX as well.
An alternative you might want to look at is using Silverlight via Lightswitch: http://team.silverlight.net/announcement/create-silverlight-applications-using-visual-studio-lightswitch/
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter