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.

I started here: http://www.microsoft.com/express/download/default.aspx

They also have lots of tutorials and stuff.

"rg" <rg01@newsgroup> wrote in message
news:eAu9k5ZXKHA.220@newsgroup

> 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.

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.
--
PeteCresswell

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.