Click here to Skip to main content
11,802,762 members (72,945 online)
Rate this: bad
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 3:24am
Wayne Gaylard at 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 at 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 at 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 at 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 at 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 at 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
0 KrunalRohit 366
1 OriginalGriff 365
2 F-ES Sitecore 295
3 CPallini 270
4 Sergey Alexandrovich Kryukov 239
0 OriginalGriff 2,950
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,695
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web02 | 2.8.151002.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