Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Comments
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

http://www.microsoft.com/en-in/download/details.aspx?id=13255
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?

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.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900