Solved

Setup file  produced by Package and Deployment Wizard unreilable

Posted on 2004-03-23
5
156 Views
Last Modified: 2010-05-01
Hi.......

I am not sure how to deal with this problem... I develped my first big VB application and needed the Pacage the Deployment Wizard to produce a Setup file that can install the application on other computers.... All goes well until I try to use the Setup file produced by the Wizard... On some computers the Setup works like a charm and the application runs without a problem, but on others the application generates an  error message informing the user that the path to the database file is incorrect.... All the computers I tried use the same operating system (XP)...... and the only difference I have noticed is that on the computers where the application ran successfully a Microstf Visual Studio 6 was previously installed....
 
the Setup file resides on a USB flash card which the computers see as a drive, and I install the application directly from that card...

Help is needed fast ..... thanks
0
Comment
Question by:tariqanis
[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
  • 2
5 Comments
 
LVL 16

Expert Comment

by:JohnBPrice
ID: 10659082
What sort of database?  Is MDAC included in your package (MDAC_TYP.exe)?  if not, does manually pre-installing the latest MDAC fix the problem?  Then include MDAC in your install.
0
 

Author Comment

by:tariqanis
ID: 10659469
The database is Microsoft Access.. only one table is used.. and this is the first time I hear of MDAC... can you elaborate a little... is it part of VB? If not how do I obtain it or how do i get the MDAC fix..?.... I am also not very sure of what you mean by "manually pre-installing the latest MDAC. Install it where...? in the folder which contains the Setup file  created by the Package and Deployment Wizard...?

0
 
LVL 16

Assisted Solution

by:JohnBPrice
JohnBPrice earned 125 total points
ID: 10660092
MDAC is Microsoft's data access client package, including Access & SQL Server.  Generally, if your app is using ADO or ODBC or Jet (Access), you need to ensure MDAC gets installed.  Typically it is installed with Visual Studio, which is what made me suspect it.  It is also installed with many apps that use Microsoft data access.  The package & deployment wizard will normally include it in your setup if your app uses ADO or data bound controls (but I'm not sure how it decides).  It's easy to check, in the package & deployment list of files to include, make sure MDAC_TYP.exe is checked.  MDAC_TYP.exe is the runtime installation.

You have one or more installs of MDAC on your machine, look for MDAC_TYP.exe, sometimes MDAC_TYP25.exe.  Likely places are Windows\System32 and C:\Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist.   Version 2.7 is the latest I know of, but anything from 2.4 up usually works and the install will not downgrade a machine if you install a version older than one already installed.

So take the MDAC_TYP.exe from your machine and run it on a problematic machine and see if it fixes the problem (or make sure it is in your install).

Of course, the problem could be completely different.  What is the path to the .mdb your project expects?  I presume you checked that the .mdb is actually there?
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 125 total points
ID: 10663579
Where is your Access database? How do you connect to it? Do all users have read-write permissions in the folder where your database is located?
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
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…

752 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