MOTOBIT.COM - ASP upload, IIS utility AddRS Method of MDB class

Method | Member of  RSConvert.MDB | Changes | Purchase | Download

Description

Adds a recordset as a table to the MDB file.

Syntax

MDB.AddRS (RS as Variant, [TableName as String])
 

Where Type Optional Default Description
 RS  Variant     Recordset to add to MDB object. 
 TableName  String  yes    Name of the table. 

Examples

Two recordsets from ADO samples

  'Create RecordSet and MDB objects
  Set ADORS = CreateObject("ADODB.Recordset")
  Set MDB = CreateObject("RSConvert.MDB")

  'Open table Orders
  ADORS.Open "Orders", "DSN=ADOSamples"
  'Add table "Orders" to database
  MDB.AddRS ADORS
  ADORS.Close

  'Open table Payments
  ADORS.Open "Payments", "DSN=ADOSamples"
  'Add table "Payments" to database
  MDB.AddRS ADORS
  ADORS.Close

  'Write MDB file to the client
  Response.BinaryWrite MDB.GetBinary

Other links for AddRS

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.

© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz