Solved

Run Time Files Needed for VB

Posted on 1998-07-15
8
462 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now