It seems you would like to migrate an Access based application to .NET.
Basically, it will take some time depending on the complexity of the
application. However, .NET framework provides greater flexibility and
extensibility, so the migration is worthwhile. Due to the different
programming model for a distributed application and desktop application,
the changes are great. This actually requires rewrite of the code.
As it is quite a large topic, which will be covered by several books, I'm
listing some articles here for your reference. These articles covers the
main technical points that may involved for developing a .NET application.
ADO .NET
=========
Basically, ADO .NET's main design consideration is that the business model
is disconnected. This improves scalability and performance of applications
(and it also provides better support for mobile users):
http://msdn.microsoft.com/library/en-us/dndotnet/html/adonetprogmsdn.asp
ASP .NET
=========
The programming model of ASP .NET is quite deferent from previous ASP. ASP
.NET separates UI design and code behind. The developers can focus on the
code, and the UI designer can focus on the UI design. The advantages are
obvious. Of course, the programming model is different:
http://msdn.microsoft.com/library/en-us/dndotnet/html/convertasptoaspnet.asp
VB .NET & .NET Framework
=========
.NET programming is not a pure language issue. It also involves the .NET
framework, such as class library, the garbage collection mechanism, etc. It
is recommended to check a related book that introduce this in series. You
may want to check the courseware of Microsoft Certified Application
Developer (MCAD) for Microsoft .NET:
http://www.microsoft.com/traincert/syllabi/2727Afinal.asp
Additionally, here are some articles that may be of help:
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconprogrammingwithnet
framework.asp
Note: The URL may wrap.
Migrating Access Database to SQL Server
=========
To migrate Access DB to SQL Server, you may want to check following article:
237980
INF: How to Convert an Access Database to SQL Server
http://support.microsoft.com/?id=237980
Additionally, you may want to check some books that introduce SQL Server
management:
Microsoft Access Developer's Guide to SQL Server by Mary Chipman and Andy
Baron
ISBN: 0672319446
Note: Mary Chipman and Andy Baron are former Access MVPs and current SQL
Server MVPs - both still teach/lecture on Access.
You can also find some related books from
http://www.barnesandnoble.com.
Related Resources
=========
There will be certainly a learning curving to get familiar with .NET
programming and create a commercial application. Personally, I think
following resources may be of help.
GotDotNet web site has many useful articles and samples. It's the official
.NET web site. The quick start tutorial is especially helpful:
http://samples.gotdotnet.com/quickstart/
Microsoft Application Blocks for .NET provides a sample library that wraps
the ADO .NET library:
http://msdn.microsoft.com/library/en-us/dnbda/html/daab-rm.asp
Duwamish sample is a great sample application that demonstrates various
part of .NET programming, including design, ASP .NET, ADO .NET,
multi-tiered business application, etc:
Download
http://msdn.microsoft.com/library/en-us/dnbda/html/bdasampduwam7.asp
- and -
Documentation:
http://msdn.microsoft.com/library/en-us/dwamish7/html/vtoriArchitecturalOver
view.asp
In addtion, this issue is more likely to be better addressed in some dotnet
newsgroup, such as:
microsoft.public.dotnet.framework
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.framework.aspnet
microsoft.public.dotnet.languages.vb
Sincerely,
Alick Ye, MCSD
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "jason" <
[email protected]>
| Sender: "jason" <
[email protected]>
|
| We've been using adp projects for quite a while. We've got
| an app with 400 forms in it. We're interested in
| converting it to a .net windows forms app but are also
| loath to give up the ease of databinding forms and
| controls in adp projects. Anybody know of 3rd party tools
| that can be used in windows forms to make the data binding
| comparable to adp projects?
|
