Go Premium for a chance to win a PS4. Enter to Win


Run Time Files Needed for VB

Posted on 1998-07-15
Medium Priority
Last Modified: 2012-08-13
I have a VB application which I compiled and went through the application setup wizard.  I am using Access as the back-end database application.  When I install the program on a computer WITH Access installed but WITHOUT VB installed, my SQL Queries don't work (invalid call or function).  When I install the program on a machine with Access AND VB, it works fine.  I realize I am missing some .dll file, but which one or ones?  How do I go about finding this out?  Obviously the App Setup Wiz missed it.
Question by:tmjp
  • 4
  • 3

Expert Comment

ID: 1465854
Check to see if the machine with Access but without VB has the following dll's...

DAO350.DLL (This one may be an earlier version of the data access library, such as DA0300.DLL or DAO250.DLL, etc.)


Expert Comment

ID: 1465855
I have given up on the setting up data access now, the only way to do it is to ship MSDAC_xx with your program and run that, it installs every kind of data access ms has ever produced.

There is a seperate 6MB install for 95, NTserver and NTworkstation, however there is a smaller 1.5MB xplatform version but I have never found it.

Now you only have to install your program and ocx's and vbruntime and c runtime and .........

Author Comment

ID: 1465856
I'll check for the files, dfhaines, and get back with my results.  

Chris a ... what is MSDAC_xx and where do I get the 6 MB version?

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Accepted Solution

chris_a earned 400 total points
ID: 1465857
You can get them here: www.microsoft.com/data/mdac15.htm

From the looks of this you can download just the redistributable bit also which should be much smaller.

Just been reading the ADO2 blurb msdn send out and the new version out soon will combine everything into a single 7.9MB file (rather than 3 x 6 MB).

ps If you download the file and run it only to find you are confronted with a wide dialog, about 6 feet, you need to get the comctl32 update from microsoft also.


Author Comment

ID: 1465858
It seems that the problem in my application is caused by the input box function.  I am searching the db for a name, first and last.  The first name inputbox comes up and the user enters a name.  "fname = inputbox( etc..." is my code.  When the user presses OK, I get the error, "Invalid Call Or Argument".  There is no SQL at that point and the user can say OK and get the inputbox for the last name.  Upon entering the last name,. however, he gets the same error and, answering that OK ends the program.  I have a feeling that this has nothing to do with my later SQL call, but rather something to do with the inputbox function, or some function it calls.  What do you think??

Author Comment

ID: 1465859
Run Time Error 5 is the error.

Author Comment

ID: 1465860
More points if anyone is able to answer this!!!

Expert Comment

ID: 1465861
Try working around the InputBox fx, do a form with the required items and make the strings public properties, you will still be able to access these after the form has unloaded since it it isn't really unloaded untill you set it to nothing.

This way is better because you have more chance to error check.

PS Remember to protect yourself from the user entering ' or " in the string.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question