Solved

Run Time Files Needed for VB

Posted on 1998-07-15
8
491 Views
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.
HELP!!!!!!!!!!!!!!!
0
Comment
Question by:tmjp
  • 4
  • 3
8 Comments
 

Expert Comment

by:dfhaines
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.)
MSJtEr35.dll
MSJInt35.dll
MSJet35.dll
VBAJet32.dll
VB5DB.dll

David
0
 
LVL 2

Expert Comment

by:chris_a
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 .........
0
 

Author Comment

by:tmjp
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?

Thanks
T.
0
Industry Leaders: 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!

 
LVL 2

Accepted Solution

by:
chris_a earned 200 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.


0
 

Author Comment

by:tmjp
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??
0
 

Author Comment

by:tmjp
ID: 1465859
Run Time Error 5 is the error.
0
 

Author Comment

by:tmjp
ID: 1465860
More points if anyone is able to answer this!!!
0
 
LVL 2

Expert Comment

by:chris_a
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.
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA filters 2 70
Looking for VB6 code to read SQL table export it to ascii 8 47
VBA: Select SQL query based on a config Sheet v2 11 52
Macro Excel - Multiple If conditions 2 87
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

679 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