none
How to recover VB project files or where are they stored? RRS feed

  • Question

  • I have an old application developed in MS Access 2003 and VB.  I made backups from the original development machine but cannot find the VB project files.  I only see the mde and mdb access files.   Where would I find the VB project files like .frm, .bas, .cls or is there way to get them from the access files?
    Saturday, February 9, 2019 6:26 PM

All replies

  • Hi Ladydi6558,

    I'm afraid it would be a hard question to answer.
    But, fortunately, you have some keys to find them, i.e. you know file extensions (.frm, .bas, .cls, etc.) to search.
    Please Search by ".frm" (or .bas, etc.) in C-drive, other drives, etc.  If you remember folder names, search in them.

    (1) Open File Explorer (AKA Windows Explorer)
    (2) Specify where to search in left pane
    (3) Type keyword in right pane (right upper)
      

    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Saturday, February 9, 2019 10:31 PM
  • Thank you , but they are not there.  I am not using the original development machine.  Does anyone know if thre is a way to get this vb project file information from an access mdb file?
    Saturday, February 9, 2019 11:52 PM
  • Hi Ladydi6558,

    I'm afraid you can NOT extract vb project file from an access mdb file.
    An .mdb file does not involve any vb project files in it.

    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html


    • Edited by Ashidacchi Saturday, February 9, 2019 11:57 PM
    Saturday, February 9, 2019 11:56 PM
  • Hi,

    Based on your description, I will move thread to Access forum:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact: tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Monday, February 11, 2019 2:35 AM
  • You mention Access and VB.  So you have a VB interface which uses an Access data file?  Or is the interface/UI Access as well and you mean VBA?

    If it is the later, Access stores everything in the mdb.  So if you have the admin rights, you can access everything, including the VBA code 

    Probably best to hire a professional if you are not familiar with Access and/or VBA.


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net



    Monday, February 11, 2019 11:37 AM
  • Open the file and use Alt+F11. If there is any VBA code associated with the project, the VBA window will open.
    Monday, February 11, 2019 2:19 PM
  • Hi Daniel Pineault (MVP),

    OP (Ladydi6558) wrote:
      Where would I find the VB project files like .frm, .bas, .cls or is there way to get them from the access files?

    I'm afraid that files such as .frm, .bas, .cls cannot be found in .mdb file.

    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Tuesday, February 12, 2019 12:17 AM
  • That's why I asked if this truly was a VB project or whether they confused frm, VBA mdl, bas ... with Access objects, which is the standard approach to Access solutions.  Access, most often, is self-contained and everything is under the hood, as they say, tables, queries, forms, reports, VBA (mdl, bas, cls).  So depending on the actual case, they may already have access to everything in the mdb/accdb and just not realize it.

    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Tuesday, February 12, 2019 1:34 AM
  • To Daniel Pineault (MVP):
        Thank you for detailed explanation.

    To Ladydi6558:
        I hope you will read our posts and provide your situation further.

    Regards,

    Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

    Tuesday, February 12, 2019 2:36 AM
  • I think you are confusing VB (as in VB6) with VBA projects. An Access database is self-contained. The VBA project is part if the database. It is not a separate file like VB projects. Nor are the objects separate, Forms, reports, queries, macros and code are all in the database file. They can be saved out as text files, but they can't be used as objects outside of the database.

    You can see the "project" by opening the database in Access and pressing Ctrl+G or Alt+F11. Both of those actions open the Visual Basic editor. Keep in mind a database can be code-free, but it's usually only the simplest databases that are.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, February 12, 2019 5:08 PM