Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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
Comments
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
 
http://www.microsoft.com/en-in/download/details.aspx?id=13255
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?
 
Explanation!:
*.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)



Advertise | Privacy | Mobile
Web04 | 2.8.1411022.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2014
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