how to publish project that have ACCESS 2010 database

Question

4.00/5 (1 vote)

See more:

Hi all

we design accounting software (N-layer application , C#.net , ACCESS 2010), We wanna

publish our project in web. In the test step ,we install software(We create setup

using Visual studio) in the many PC we face the following error :

Attention: we release our project in X32 Configuration.

When Install in the pc that have office 2010 (X64) , we face following error :
Unrecognized Database Format x.accdb

solution that we test and have problem :
install two package:
1) AccessDatabaseEngine(Data_conectivity2007)... solution that find in web.
site:http://www.microsoft.com/en-us/download/details.aspx?id=23734[^]
2)AccessDatabaseEngine 2010.

in last we force to delete office package and install two above package and application run correctly.(that it is problem).

but in any pc that have office 2007 (X32 or X64) or office 2010(X32) not X64 with install two above package, application run correctly.

Question:
Is there best solution to know what is version office that install in PC ??

how We know what's deadline in target system ? for example (.net frame work 4 or above two package ) and setup automatically install that package.

thanks a lot.

Posted 20-Apr-15 4:21am

bernova

Updated 20-Apr-15 4:26am

v3

Add a Solution

Comments

Maciej Los 20-Apr-15 12:12pm

MS Access is not included each version of MS Office. I'd suggest at least to install AccessDatabaseEngine 2010 every time when you install your application. Project should be built with "Any OS" option.

bernova 23-Apr-15 4:38am

thanks a lot.

Maciej Los 23-Apr-15 4:39am

You're very welcome ;)
Does it help?

bernova 23-Apr-15 8:33am

yeeeees. thanks a lot.
I release my solution as AnyCpu configuration . and test in many pc . that's right idea.

Maciej Los 23-Apr-15 8:50am

I posted my first comment as an answer. Please, be so kind and accept it (green button) to remove your question from unanaswered list. Cheers, Maciej.

Maciej Los 24-Apr-15 6:14am

Thank you for accepting my answer.
Cheers, Maciej

bernova 23-Apr-15 8:34am

in the next version of application , we change database to sql server , because we have been forced to use access database , we should write VBA code for security and hide table and set password , but it is Vulnerable.

Maciej Los 23-Apr-15 8:50am

Good idea!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Accepted Answer · 2015-04-23T02:49:00

Solution 1

MS Access is not included each version of MS Office. I'd suggest at least to install AccessDatabaseEngine 2010 every time when you install your application. Project should be built with "AnyCPU" option.

Posted 23-Apr-15 2:49am

Maciej Los