VB6/Access97 under Win7 RRS feed

  • Question

  • I have a legacy VB6 application written using Access 97 MDB and DAO that must
    run under Wndows 7 and Access 2007. A few questions:

    1. Can I use DAO with VB6 and win7 with office 2007 installed? If so, what
    version of DAO files should I use, and has it been tested or certified?

    2. Am I better off switching to ADO with Access, and if so, why?  And if so,
    what version? Will this make the conversion more time consuming and expensive
    because we have to modify extensive program code?  

    3.  What combination of VB6, win7, and MS Access does MS recommend when
    office 2007 is installed on machines? And will this combo still work if a
    particular user has upgraded to Office 2010 (before or after my software is
    installed), but I am using/installing Office 2007 jet Access engine

    4. Do they (MS) have suggestions as to who to look at for text box, grid,
    data control, etc? I'm using Crescent controls and the protoview grid and
    need to know if they are compatible.


    Wednesday, September 22, 2010 1:22 PM


  • Hi Carl,


    Thanks for the post!


    Since the different requirement of users, the combination might be different. Meanwhile, your questions are mostly related to the development, as this Windows 7 forum is focused on answering usage-related questions about Windows 7, in order to resolve your problems efficiently, I recommend you ask question in http://social.msdn.microsoft.com/Forums/en/category/visualbasic, it’s more professional on development.


    Thanks for understanding and cooperation!


    Best Regards,

    Miya Yao

    This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Miya Yao Thursday, September 30, 2010 9:46 AM
    Friday, September 24, 2010 5:39 AM