CODEWITHSUNDEEP
visual-studio-2010ms-access
John Moore
John Moore

Reputation: 519

Is there an easy way to distribute the Access Database Engine

I'm using an Access Database (accdb) with my VB 2010 Application

I know I need to install the Access Database Engine on each workstation that needs to run my program.

However, I can see a logistical nightmare if I have to manually install the Access Database Engine on 100+ workstations manually.

I know a MSI doesn't exist. I'm looking for a solution to automate the installation of the Database Engine when the software installs.

Has anyone else overcome this problem.

Upvotes: 3

Views: 464

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123409

If your application does not use any database features specific to the .accdb file format then you could greatly simplify matters by using an .mdb file to store your data. You could target your VB.NET project to the x86 (32-bit) environment and have it use the Microsoft.Jet.OLEDB.4.0 provider that is included with every Windows install. That way you could just distribute your app without having to worry about installing ACE.

Upvotes: 3

Related Questions