There are utilities that will convert your VBA code to C# or VB.NET,
but for the most part you'll need to rewrite code that uses recordsets
because there is nothing analogous in .NET. There is more for the data
side, such as the SSMA Migration Assistant site, which also has links
to other resources. http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx.
Third parties, such as FMS, also have migration resources. http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx. HTH,
Now you need to find that "software architect" who decided to put the whole
thing in Access....instead of using just the Jet database (.mdb file).
The JET database would not have been the greatest, but it would not have
killed you either.
