• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Installing application that uses ADO on an MDB

Which files do I need to install at the user's computer so an application I wrote which uses ADO code to access an MDB database would work ?
(Assuming the users doesn't have MS-Access installed)
  • 2
1 Solution
Use the deployment wizard :

To start the Package and Deployment Wizard from within Visual Basic

Open the project you want to package or deploy using the wizard.
Note   If you are working in a project group or have multiple projects loaded, make sure that the project you want to package or deploy is the current project before starting the wizard.

Use the Add-In Manager to load the Package and Deployment Wizard, if necessary: Select Add-In Manager from the Add-Ins menu, select Package and Deployment Wizard from the list, then click OK.

Select Package and Deployment Wizard from the Add-Ins menu to launch the wizard.

On the main screen, select one of the following options:
If you want to create a standard package, Internet package, or dependency file for the project, click Package.

If you want to deploy the project, click Deploy.

If you want to view, edit, or delete scripts, click Manage Scripts.
For an introduction to these options, see "The Package and Deployment Wizard."

Proceed through the wizard screens.

If your application uses ADO, OLEDB, or ODBC components, the wizard automatically adds a file called mdac_typ.exe to the list of files to include in your package. Mdac_type.exe is a self-extracting executable that installs all of the necessary components you need for your data access technology.

The wizard prompts you to choose the appropriate data access option when your application includes DAO features. You choose the appropriate method — ISAM-based, ODBCDirect, ODBC through Jet, etc.
As Kimda says: run Mdac_type.exe
xozAuthor Commented:
The wizard didn't automatically add this file, though I used ADO code...
No, that's true. You'll have to remember to make it part of your setup procedure. Sorry, life's not easy in the world of Micro$oft software...

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now