How do I begin thinking on converting MS Access ap to web based/Dot Net

  • Thread starter Thread starter rg
  • Start date Start date
R

rg

Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.

Where do I begin researching/determining how to convert an MS Acess app to
dotnet?

Old VB6 coder here but not sure that is too relevant today.

Thanks.
 
Per rg:
Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.

Where do I begin researching/determining how to convert an MS Acess app to
dotnet?

Old VB6 coder here but not sure that is too relevant today.
Click to expand...

I'm in a similar situation except I'm a current MS Access
developer whose current gig seems tb in it's final days/weeks.

Based on a couple of apps I "converted" to VB6 just to see how
the man hours stacked up (a factor of 3 for me), I would say to
think in terms of total rewrite instead of conversion.

My intent is to select a fairly basic application that I have
developed in MS Access and rewrite it using .NET with windows
forms and the freebie SQL Server back end.
 
It really depends on what you have done, the complexity, and how it is all
tied together. That said, databinding in .NET is confusing at first but
really quite brilliant. I converted a program from Access to .Net about a
year ago and while not difficult, I should have learned more about
databinding first. Since learning much more I was able to recreate almost the
entire project with very little code. It is much faster, simpler, and the
footprint is about 1/3 the original.
Look in to drag and drop binding to get you started. Not to over promote,
but in my "blog" in the sig i have written several tutorials related to
databinding in VS you might find helpful.
 
My 2 cents from my own experience as a new latecomer to VB from
Access:

1. Realize that the data connection and retrieval work is actually
made really easy in the current versions of VB.
2. Learn how to use variables (if you don't know how already) instead
of storing data on invisible form controls.
3. Read up, ask questions and look at samples before you try to
recreate a control, sub or behavior the way you know how in Access.
4. Watch the videos under Learn Visual Basic on the MS website (http://
msdn.microsoft.com/en-us/vbasic/default.aspx) - they're helpful to
learn how to move around quickly and what you don't have to do by
hand.
5. Learn about doing things - like building controls - from code.
Saves lots of time once you get the hang.
6. Use this group as a resource - they're very helpful!!

Patrick.
 
Back
Top