Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-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!

*Tek-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

Creating Setup Files

Creating Setup Files

Creating Setup Files

I am developing a mutli-user app that uses mostly DAO to connect to an Access DB on a file server. When I run the app from my PC it connects fine, but when I create a setup file and install it on another machine the app fails to connect to the server. The only way I found to resolve this is to install VB on the target PC and make the executable on that PC. It is not reasonable that I should have to install VB on each machine that I desire to run my app. Am I neglecting to include some support files in the package?

RE: Creating Setup Files

It seems like you missed some files, try to include the odbc drivers and the DAO dlls.
Also, check the reference to the database, maybe it is looking somewhere else, it happened once to me.

RE: Creating Setup Files

Also look out for different versions of ODBC and it's drivers.

RE: Creating Setup Files

You may have to redistribute the DAO stuff. It's in a huge file called MDAC_TYP.EXE. There is a command-line interface to this program (so it'll run silently), as I have seen other setup programs run it, but don't know what they do to get it to do it.

Also, there was a KB article about developers shipping a VB5 app from their machines, when they also had VB6 installed. Seems a new file must be distributed called Expsrv.dll, that is required for backwards-compatability with data-access. This file isn't known to the VB5 setup wizard, so you have to slip it in manually to your setup program.

Chip H.

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 Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

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

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close