Compress Property, MDB class

Description

Compress method or command line to real-time compress output file. Specifies one of predefined values (pkzip.exe, arj.exe) or full command line for compress program. GetFile and GetBinary methods calls the program after create database.

Syntax

vCompress = MDB.Compress
MDB.Compress = vCompress

Returns

String

Remarks

Predefined values :

Zero length string - no compress

1 - pkzip, pkzip.exe -a <output> <input>

2 - arj, arj.exe a -e <output> <input>

Examples

Compress outgoing file by PKZIP.EXE

  'Create Recordset and MDB objects
  Set ADORS = CreateObject("ADODB.Recordset")
  Set MDB = CreateObject("RSConvert.MDB")
  
  ADORS.Open "Payments", "DSN=ADOSamples"
  
  MDB.Compress = 1
  'Write zipped MDB file to the client 
  Response.BinaryWrite MDB.GetFile(ADORS)

Methods of MDB class

AddRS, GetBinary, GetFile

Properties of MDB class

Compress, DBFileName, Options, RowCount, TempDirectory

RSConvert.MDB

Object for converting DAO or ADO recordset to the MDB file. Faster than DBF, MDB enables distribute large binary and text fields.

RSConvert

Recordset converter is a library for converting DAO or ADO recordsets to MDB or DBF files. It enables direct binary output of MDB or DBF files from ASP pages with one row of code. The object also supports on-the-fly compression by zip/arj.