I think Crouchie is yanking your chain. It's not at all simple or
straightforward because Access works entirely differently than a
VB.NET Windows application. Access was designed over a dozen years
ago, pre-Internet, to be a desktop database application that worked
well on a LAN with users being continuously connected to the data
source. It makes extensive use of the network and hard drive, and does
a lot of the data binding and heavy lifting for you. .NET was designed
primarily with web applications in mind, and is designed to work with
data in a disconnected mode, where data is fetched and stored in a
local cache. Forms need to be hand-crafted, and many common features
found in Access simply aren't there, you have to build them yourself.
Syntactically VB.NET isn't that much of a stretch from VBA, but that's
only the beginning of your learning curve. Because of the drastic
differences between the two platforms, it would be impossible to build
a tool that would automate the process of converting a complex
application for you.
--Mary
