×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Creating Installer for ADOX Program

Creating Installer for ADOX Program

Creating Installer for ADOX Program

(OP)
I used ADOX to implement a File New menu item that creates a new .mdb file. It worked perfectly for development, but is causing problems now that I am trying to create an installer.

The first indication of a problem I get is when I first add a setup project to my solution. A message box says:

The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.

c:\program files\common files\system\ado\msadox.dll

If I just press the OK button, and proceed with creating the installer, everything seems fine until I try to build it, at which point I am told that:

C:\Documents and Settings\Desktop\Setup1\Setup1.vdproj 'msadox.dll' should be excluded because its source file 'C:\Program Files\Common Files\System\ADO\msadox.dll' is under Windows System File Protection.

When I searched the web for phrases from this error message, I found very little. A response to one person's query on a newsgroup was "just exclude the file from the deploy project". Later I did indeed simply exclude msadox.dll from the Setup project, and the solution did then successfully build. But, as pointed out by one person on the web whose newsgroup query went unanswered, if the program is then installed on a computer, using any features that require the excluded file will crash the program. If I try to use the New menu item on my program after installing it, I get the following error message:

System.IO.FileNotFoundException: File or assembly name Interop.ADOX, or one of its dependencies, was not found.

(Apparently some programs will still work even with excluded DLLs, as long as other necessary programs are also on the computer, but this can't be true in all cases; the computer I installed my program on did have Access on it.)

A couple of things I've already tried in order to fix the problem are adding the MDAC merge module to my setup project, per the instructions at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q320788, and installing versions 2.7 RTM and 2.8 of MDAC (which is said to contain the ADOX DLLs) from http://www.microsoft.com/data/download.htm. Neither seemed to have any effect.

Does anyone have a solution?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources