ODE97: Error Running Jetcomp.exe with Access 97 Run-Time Database (184582)
The information in this article applies to:
- Microsoft Access 97
- Microsoft Office 97 Developer Edition
This article was previously published under Q184582 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you try to use Jetcomp.exe to compact a Microsoft Access 97 run-time
database, you may receive one of the following error messages:
Can't Initialize VBA.
A required .DLL file, VBAJET32.DLL, was not found.
The dynamic link library VBAJET32.DLL could not be found in the
specified path <pathname>.
CAUSE
Running Jetcomp.exe generates this error when both of the following
conditions are true:
- The database is part of a run-time application that you created with the Microsoft Office 97 Developer Edition Tools (ODE) Setup Wizard.
- Microsoft Access 97 or Microsoft Office 97 Professional Edition has not been installed on the computer where you installed the run-time
application.
RESOLUTION
The Compact utility in Microsoft Jet Database Engine version 3.51 allows
you to recover most corrupted databases. You can use the ODE Setup Wizard
to create a shortcut with which users can compact a database in your run-
time application. For more information, search the ODE Tools Help Index for
"shortcuts, in Setup Wizard." If you want to manually create a shortcut
that you can use to compact the database in a run-time application, search
the ODE Tools Help Index for "compacting, data in run-time applications."
However, if you can't recover a corrupted database with the Compact utility
of Microsoft Jet, and if you want to try to compact the database with
Jetcomp.exe, use one of the following two methods to prevent the errors
described in the "Symptoms" section.
Method 1
Add Vbajet32.dll and Vbar332.dll to the List Of Files in the ODE Setup
Wizard. To do so follow these steps.
NOTE: If you search the ODE Tools Help Index for "distributing, files with
run-time applications" and click Display, Vbar332.dll does not appear on
the list of files that you can distribute with your run-time application.
However, you may still include it in the list of files that you want your
custom Setup program to copy.
- Start the ODE Setup Wizard.
- On the first screen of the Setup Wizard, select Use Previously Saved
Setup Options and click Next.
- In the Load Template dialog box, click the .mdt template file that
contains the setup options for your run-time application. Click Open.
- Add the following .dll files, which are located in the Windows\System or
Winnt\System32 folder, to the list of files that your want your
custom Setup program to copy:
Vbajet32.dll
Vbar332.dll
- Click Next to continue through the rest of the Setup Wizard and rebuild
the disk images.
- Run Setup to install the run-time application on a computer that is not
running Microsoft Access 97 or Microsoft Office 97 Professional Edition.
Method 2
Add the Microsoft Replication Manager component to the run-time
application. To do so follow these steps:
- Start the ODE Setup Wizard.
- In the first screen of the Setup Wizard, select Use Previously Saved
Setup Options and click Next.
- In the Load Template dialog box, click the .mdt template file that
contains the setup options for your run-time application. Click Open.
- Click Next until you see the screen that allows you to add
redistributable components to your custom Setup program.
- Select Microsoft Replication Manager.
- Click Next to continue through the rest of the Setup Wizard and rebuild
the disk images.
- Run Setup to install the run-time application on a computer that is not
running Microsoft Access 97 or Microsoft Office 97 Professional Edition.
Note that the Microsoft Replication Manager component includes 12
additional files. Your application may not need these additional files
if you are not using Microsoft Replication Manager.
Modification Type: | Major | Last Reviewed: | 10/20/2003 |
---|
Keywords: | kbprb KB184582 |
---|
|