Writing a program
I will be writing a program for my wife's company. She does have a program written (in VB) but it is outdated. It uses Access'97 for a database.
I plan on using VC++ 6 and Access 2000. I don't know much about VC++. I did know C++ (many moons ago...) and relearning that part of it shouldn't be too difficult. I don't have any experience with VC++.
Any advice before I get started ?
Pick up the book 'Inside COM' if you plan on automating access or using ado. In fact, pick up a book on ado as well (not ado.net).
Make use of ODBC. That way you can switch from Access to SQL server when Access cannot handle it anymore...
But why not import the old program in a new VisualBasic compiler, modify it and recompile?
Or is it build using VBA (VisualBasic for Applications; the stuff that's build into every Office application)?
Erm, no. Go ADO.
ODBC is a lower level api and isn't exactly the most pleasant thing to work with. Using visual c++ you can easily use the ADO com interfaces to do everything you want with either database with less work.
There are also plenty of examples on the internet. Google is your friend.
Ah. Ok. Learned something :D I usually don't dabble with VC++. I mostly do my stuff in perl. With perl it's easy to use ODBC with DBI+DBD::ODBC or Win32::ODBC.