Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Convert MS Access database into a stand-alone program

Discussion in 'Information Technology' started by Marixxe, Jul 28, 2006.

  1. Marixxe

    Marixxe
    Expand Collapse
    Guest

    Hi there!

    I just want to ask if its possible to make my MS Access Database into a
    stand-alone program? I mean, no need for MS Access software to run it. If its
    possible, I would to know how. Thank you.

    Marixxe
     
  2. Loading...

    Similar Threads Forum Date
    Sikhconvert Joins Sikh Philosophy Network! New SPN'ers Aug 28, 2016
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Islam Ishna Has Converted To Islam Interfaith Dialogues Apr 1, 2016
    A Christian Missionary tried to convert me. Blogs Oct 22, 2015
    "Convert's Corner" - Ideas for Retitle? Convert's Corner Oct 21, 2015

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    It's not possible to convert an Access application into an executable.
    Assuming that you want to allow peopel who do not have Access installed to
    use your application, you have 3 main options:

    1) Rewrite your application in a language that can be compiled into an
    executable, such as VB or VC++ (note that your data will still have to be
    kept in an external MDB file)

    2) Rewrite your application as a web app

    3) Get the Access Developer edition that's appropriate for whatever version
    of Access you're using (see
    http://www.granite.ab.ca/access/developereditionversions.htm for details of
    what you need to look for) What this allows you to do is package your
    application together with a royalty-free run-time version of Access. Users
    who don't have Access installed will be able to install the run-time and use
    your application. They will not be able to use the runtime to make design
    changes to your application (nor to any other MDB)

    You need to purchase the following in order to create an Access 2003 runtime
    application:

    - Microsoft Access 2003
    - Visual Studio Tools for Office 2005 (which includes the Access 2003
    Developer Extensions)

    The ADE is the product that gives you the license to deploy the 2003 runtime
    components and you have to have Access 2003 installed in order to install
    the ADE.

    See http://msdn.microsoft.com/office/understanding/vsto/default.aspx for
    more details, or
    http://office.microsoft.com/en-us/assistance/HA011208861033.aspx


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Marixxe" <Marixxe@discussions.microsoft.com> wrote in message
    news:66A7AD18-012C-4B1B-963A-C0C69C485D62@microsoft.com...
    > Hi there!
    >
    > I just want to ask if its possible to make my MS Access Database into a
    > stand-alone program? I mean, no need for MS Access software to run it. If

    its
    > possible, I would to know how. Thank you.
    >
    > Marixxe
     
  4. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Marixxe.

    > I just want to ask if its possible to make my MS Access Database into a
    > stand-alone program?


    No. The MDB file is just a container to hold data. It's not an executable,
    "stand-alone" file.

    > I mean, no need for MS Access software to run it.


    Of course you don't need Microsoft Access to run it. If you have a modern
    version of Windows, then you have service packs that contain Microsoft Data
    Access Components (MDAC) 2.5 (which contains the Jet DLL's) and MDAC 2.8 to
    access the data in the MDB file from another software application. All you
    need to do is write an application that can interact with MDAC and the
    Microsoft-proprietary Jet libraries. If you have a lot of experience with
    these types of projects, then it might take about 20,000 or 30,000
    man-hours, but if you don't, then even 100,000 man-hours might be on the
    conservative side.

    So what programming language were you planning on using for your
    application? Is your application going to be command-line driven or a GUI?
    Will it port to Linux and Unix (or maybe even a Mac)? If you port it to
    other popular operating systems, I'll bet you could get some help with other
    programmers involved in Open Source.

    Most of the rest of us are too lazy to take on such a massive project and
    would rather just spend a few hundred dollars for the Microsoft Access
    application, but I commend you for your fortitude.

    And while your organization is waiting for you to finish building your
    application, tell them that they can look into installing the Microsoft
    Access Runtime on any of their computers that don't have the retail version
    of Microsoft Access already installed. The Access Runtime won't allow the
    user to alter the design of the Access database application, but it will
    allow the user to do data entry in an environment that otherwise acts just
    like the Access GUI (for the most part). Purchasing the Visual Studio Tools
    for Office 2005 and either Microsoft Access 2003 or Microsoft Office 2003
    Pro will give the owner a license to distribute the Access Runtime on an
    unlimited number of computers. For more information, please see the
    following Web pages:

    http://msdn.microsoft.com/vstudio/products/compare/

    http://msdn.microsoft.com/vstudio/howtobuy/default.aspx

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Marixxe" <Marixxe@discussions.microsoft.com> wrote in message
    news:66A7AD18-012C-4B1B-963A-C0C69C485D62@microsoft.com...
    > Hi there!
    >
    > I just want to ask if its possible to make my MS Access Database into a
    > stand-alone program? I mean, no need for MS Access software to run it. If
    > its
    > possible, I would to know how. Thank you.
    >
    > Marixxe
     

Share This Page