As someone who migrated to .NET three years ago from an ACCESS
background - exclusively ASP.NET so far - I'd say you've got a very
steep learning curve ahead. There are no off-the shelf migration tools
that I know of (though on Monday I'm going to try a freebie that
purports to convert ACCESS reports into Crystal Reports). You might
get some added value from cutting and pasting your existing VBA into
the code-behind (stick to VB.NET, rather than C#) but it won't compile
first time and you'll really just be able to use it as pseudo-code.
However, while there are obvious similarities there are also "gotchas"
that get me even now (for example, if your form has a text box called
txtLoginName, you have to write txtLoginName.Text to get the value,
otherwise you get the text box object in all its redundant glory. And
it either doesn't build or doesn't run because you're inevitably trying
to save the value to a variable or write it to a database table.)
There are plenty of good books out there BUT you will probably benefit
from some background reading in OO as well. I should also mention that
..NET is an incredibly richly featured set of tools and it won't be
until you've immersed yourself a bit that you get a flavour of which
bits are of use, and which can be safely ignored for the time being.
In ASP.NET everything is "unbound" because browser apps are inherently
stateless.
Get used to using Try/Catch blocks instead of OnError.
However, if you manage to climb this wee hillock, you're probably onto
a good thing. Most of our clients for whom we have provided ACCESS or
VB apps over the past ten years are coming to us for rewrites in
ASP.NET. It's great for them because application distribution is such
a snap - you just expose the login form on the Intranet and give
everyone with access rights a username and password.
But try with a trivial example first.
Good luck.
Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk
We are what we repeatedly do. Excellence, then, is not an act, but a
habit - Aristotle
Those heights by great men reached and kept
Were not obtained by sudden flight,
But they, while their companions slept
Were toiling upward in the night
- Longfellow