Object for converting DAO or ADO recordset to the MDB file. Faster than DBF, MDB enables distribute large binary and text fields.
| AddRS | Adds a recordset as a table to the MDB file. | |
| GetBinary | Returns the MDB file as binary. | |
| GetFile | Retrieves the recordset as a binary MDB data. If the Compress is specified, GetFile returns output of the compress program. |
| Compress | 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. |
| String, RW | |
| Options | Format of output MDB file. |
| DatabaseTypeEnum, RW | |
| RowCount | Maximum recordset rows that RS Convert copies into a file. Zero means all recordset rows. |
| Long, RW | |
| TempDirectory | Temporary directory for creating output file. |
| String, RW | |
| DBFileName | Returns FileName of the MDB database. |
| String, RO |
Send two recordsets in MDB |
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
'Sets the content type
Response.ContentType = "application/vnd.ms-access"
'Specify filename for download
Response.AddHeader "Content-Disposition", "attachment;filename=Results.MDB"
'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
</SCRIPT> |
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