Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Run Time Files Needed for VB

Posted on 1998-07-15
8
Medium Priority
?
513 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 2

Accepted Solution

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


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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

705 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