none
how to make exe file in access 2013 RRS feed

  • Question

  • Dear Users,  

    with the help of this forum, i have prepared an access database and i am very happy....actually my database is purchase history of our company. as a new inquiry comes to us first step is to prepare a price history regarding this inquiry's partnumbers up to this i have done.....my question is now about preparing an exe file of this database . now i want when i start the access 2013 it ask me for importing the new inquiry file and then it returns me the price history file. how can i do if in the starting it shows a menu its very good.

    Thanks a lot


    Tahir Mehmood

    Tuesday, April 19, 2016 6:30 AM

Answers

  • You cannot convert an Access database to an EXE file without redesigning the entire user interface in another programming language like C# or VB.NET. If you want to compile your database into an ACCDE all you need to do is make sure the code compiles and then go to the File tab and select Save and Publish>Make ACCDE.

    That will strip out the editable code thus protecting all forms, reports, code from being modified. It will also make it impossible for a user to make a new form, report or module in that database. The original database is left untouched so you can still do developing in it.


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

    • Marked as answer by Tahir-Mehmood Monday, April 25, 2016 3:14 AM
    Tuesday, April 19, 2016 3:11 PM
  • There is a free “runtime” version of Access.

    You as a general rule can then “compile” the accDB into a accDE. However, the end result is NOT some .exe file.

    I explain the use of the runtime with Access here:

    http://www.kallal.ca/RunTime/Index.html

    The runtime version will thus require to you “build” some forms that the user interacts with, since the built-in features of access not exposed. However most of the “features” of Access are available, you as the developer have to provide menus (forms) etc. to run those built in features. The above article also touches on this issue.

    Regards,

    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    kallal@msn.com

    • Marked as answer by Tahir-Mehmood Monday, April 25, 2016 3:14 AM
    Tuesday, April 19, 2016 5:50 PM

All replies

  • I think way back with Access version 2003, there were Developer Tools to create an EXE package of the database. But now, I am not sure anything like it still exists for newer versions of Access. I could be wrong though. Good luck!
    Tuesday, April 19, 2016 2:40 PM
  • You cannot convert an Access database to an EXE file without redesigning the entire user interface in another programming language like C# or VB.NET. If you want to compile your database into an ACCDE all you need to do is make sure the code compiles and then go to the File tab and select Save and Publish>Make ACCDE.

    That will strip out the editable code thus protecting all forms, reports, code from being modified. It will also make it impossible for a user to make a new form, report or module in that database. The original database is left untouched so you can still do developing in it.


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

    • Marked as answer by Tahir-Mehmood Monday, April 25, 2016 3:14 AM
    Tuesday, April 19, 2016 3:11 PM
  • There is a free “runtime” version of Access.

    You as a general rule can then “compile” the accDB into a accDE. However, the end result is NOT some .exe file.

    I explain the use of the runtime with Access here:

    http://www.kallal.ca/RunTime/Index.html

    The runtime version will thus require to you “build” some forms that the user interacts with, since the built-in features of access not exposed. However most of the “features” of Access are available, you as the developer have to provide menus (forms) etc. to run those built in features. The above article also touches on this issue.

    Regards,

    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    kallal@msn.com

    • Marked as answer by Tahir-Mehmood Monday, April 25, 2016 3:14 AM
    Tuesday, April 19, 2016 5:50 PM
  • Hi, Tahir-Mehmood

    According to your description, please correct me if I have any misunderstandings on your question, Package Solution Wizard has been removed: 

    http://office.microsoft.com/en-us/access-help/discontinued-features-and-modified-functionality-in-access-2013-HA102749226.aspx

    So I suggest that you could follow Bill and Albert D's suggestion.

    In addition you could refer this helpful link about Pin to start accde or accdb files in windows 8


    Wednesday, April 20, 2016 5:37 AM