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.
...........
Good luck.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.