MS Access Runtime with VB.NET

Posted on 2006-04-17
Last Modified: 2008-03-04
I have created an application in VB.NET with MS Access 2000 as the backend.  My users do not have MS Access installed on their PCs.  

i have tried to install the MS Access Runtime 2000 on the PC, then install my application but when I go to run the application, nothing happens.  I seem to be able to run my application from my PC which has MS Access 2000 fully installed but have issues running on another PC.

All PCs are running Windows XP.

Can anyone help on what else I would need to install on each PC to be able to run my application?  Don't want to purchase a full licence of MS Access to install on each PC.
Question by:chellert
    LVL 39

    Expert Comment

    If you are only using Access as your data source you should not need to install anything as the Jet drivers are now distributed as part of the OS.

    LVL 38

    Expert Comment


    Author Comment

    I have tried without the MS ACcess 2000 Runtime component and nothing happens once again.  When I install the Runtime component, nothing.  When I install the full version, it works.  I have to be missing something
    LVL 77

    Accepted Solution

    Hi chellert,
    As said previously, if you are just using an mdb file  to provide the data store there is no requirement to install Access.  The 'Access' part of MS-Access is the application development tool used to create queries/forms/reports.  Tha tables are stored in a JET database. Every computer in the world that runs Windows has the JET drivers installed (of course they might not be up-to-date).
    However, if you have created other objects within the mdb file and are trying to run say, Access forms or reports from your VB app then yes, you will require MS-Access to be installed.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now