GetFile Method, MDB class

Description

Retrieves the recordset as a binary MDB data. If the Compress is specified, GetFile returns output of the compress program.

Syntax

vGetFile = MDB.GetFile (RS as Variant, TableName as String)

Where	Type	Optional	Default	Description
RS	Variant			ADO or DAO recordset to save
TableName	String			Name of the table.

Returns

Binary safe array

Examples

Simple zipped 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.

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.