MS Access Runtime with VB.NET

Posted on 2006-04-17
Medium Priority
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

ID: 16470885
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

ID: 16470950

Author Comment

ID: 16471190
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

peter57r earned 375 total points
ID: 16471347
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.


Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

850 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