Click here to Skip to main content
11,927,378 members (48,867 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB VS2010 VB.NET
Hi All,

I have built an application which wants to access Excel page, it works fine only if Access Database Engine is installed in machine, Now the question is How can I make the application work properly without installing Access Database Engine in other machine or how to make it to install as dependency without installing seperatly but gets installed automatically. I am using 1 click setup to develop the Setup.
Posted 15-Mar-13 4:24am
Wayne Gaylard 16-Mar-13 1:22am
How are you accessing the spreadsheet ? If you are using ms interop then you need to have Office installed on the machine using your application. The only way to get aaround this is to use OleDb and ADO.Net
sagarjainhr 17-Mar-13 2:08am
I am using Microsoft.ACE.OLEDB.12.0 to access. How can I make it to install AccessDatabase with click once
adrian@csdev 21-Mar-13 20:00pm
Go to this weblink and download both 32bit (25.6 MB) and 64bit (28.1 MB) packages and add them as pre-requisites in your applications installer
sagarjainhr 25-Mar-13 2:10am
Adrian thanks it worked for me, now the problem is that even though the AccessDatabaseEngine is installed it ask for installation. If I click on cancel than whole Setup will be cancelled, Is it possible to make it precheck whether the AccessDatabase is installed in machine before installing with it???
adrian@csdev 25-Mar-13 9:56am
My next question to you is what is the extension on your database is it *.mdb or *.accdb and is there an instance of Microsoft Office Access installed on the pc that you wish to install your program?

*.mdb uses the Microsoft.Jet.OLEDB.4.0 Drivers for Access 2003 and later
*.accdb uses the Microsoft.ACE.OLEDB.12.0 Drivers for Access 2007 and earlier,

If that is the case of your issue then just migrate your database from a *.mdb to a *.accdb, which means is find a pc with Office 2007 or 2010 and just copy your tables, queries, forms and views and change your database extension in your app.

If that is not the case of your issue, then email me at info @ csdev . co . za (No spaces inbetween) and I will write you a small sample project inorder to check if the provider exists.
sagarjainhr 25-Mar-13 14:20pm
Microsoft.ACE.OLEDB.12.0 Driver I am using,

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web03 | 2.8.151126.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100