Visual Basic Forum for Visual Basic Programmers VB

[jerryham]

i have written a vb program that accesses a large (DAO) database.

i used vb-6 with sp-6 and the standard package and deployment wizard.

i had the package and deployment wizard zip the database into the cab file.

the resulting distribution cd contains the cab file, an autorun file, and a modified setup.lst file (to create the desktop icon).

installing the program on another pc works fine when using a test database.

but .. when i use the full 1,000,000 record database .. it creates the cab file ok .. but the built-in zipped database is corrupted.

the distribution cd installs ok but when i try to run it, i get a database 3343 error .. and it is not fixable.

the problem has to do with the size of the database.

the test database is 10-meg .. zipping down to 7-meg.

the full database is 1.2-gig .. zipping down to 211-meg.

i have another program that uses a database of 154-meg .. zipping down to 58-meg .. and it works ok.

??? question ??? is there a documented limit to the size of the file that can be included in the cab file ???

if yes, then how do you get the installation process to install a large file ???

jerry

[vbman995]

Instead of using the Package and Deployment Wizard, try using Microsoft's Visual Installer 1.1. If you legally own Visual Basic 6 or any of the Visual Studio Products, then this installer is FREE to use.

http://msdn.microsoft.com/vstudio/downloads/tools/vsi11/default.aspx

Download both setup1.exe and setup2.exe.

Good Luck!