Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

Search: 

  Tutorial: ASP Database Related Compact MDB database Tutorial

Two ways to compact (compress) MDB database directly from the ASP/VBS using DAO 3.5 or JRO (MDAC 2.1).

Tutorial Details:

ADB database related to ASP

You can compact MDB database directly from the ASP (VBS) by DAO or JRO :

1. DAO engine (DAO 3.5 must be installed)
Set Engine = CreateObject("DAO.DBEngine.35")
Engine.CompactDatabase "path\database.mdb", "path\compacted_database.mdb"

2. JRO (At least MDAC 2.1 must be installed)

Set Engine = CreateObject("JRO.JetEngine")
Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=path\database.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\compacted_database.mdb"

Either DAO or JRO does not support compact to the same file name. You must create temporary compacted database and then copy the temporary file over original database.

See also for 'Compact (compress) mdb database from ASP/VBS script.' article: Convert MDB database to another format (JET, access version) How to convert Access database from one format to another format from ASP/VBS script.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
ASP Database Related Compact MDB database Tutorial

View Tutorial:
ASP Database Related Compact MDB database Tutorial

Related Tutorials:

Displaying 1 - 50 of about 2285 Related Tutorials.

VB and ASP programmers
VB and ASP programmers VB and ASP programmers...;  Position Vacant: VB and ASP programmers  Job Description  Visual basic programmer with ASP knowledge to develop
 
JDBC - Java Database Connectivity Tutorial
to manipulate data stored into the database. Here is the complete tutorial on JDBC... operation. Tables in a database can be related to each other with keys... JDBC - Java Database Connectivity Tutorials JDBC
 
MySQL Database
; The MySQL PHP Web Database This is a tutorial on how to create a web database... is a database to manage web site links. The concepts in this tutorial apply to most web... at using the free MyODBC driver to talk to a MySQL database from an ASP script
 
Create a database
Create Database in SQL,SQL Tutorial Create a database           ...;   In this section, we will teach you to create a database
 
Database Engines
Java: Database Engines Java NotesDatabase Engines To use a database system from Java use the JDBC... over the Internet. To package a database engine with your program, you
 
Database driven webservices
WebService with database Mysql, Webservices database, Develop database driven webservices WebService with database Mysql - A database driven webservice   
 
Database books
Database books Database books... in Relational Database Management Systems (RDBMS). SQL provides commands through... for developing client/server database applications.      
 
Create Table in Database
for the beginners, to create a table in database. In this Tutorial, we are using... Create Table in Database Create Table in Database          
 
Creating a Database Table
JDBC Create Table,Create Table JDBC,Database Table Creation,Create Table Java,Creating a Database Table Creating a Database Table...;   Database: A database is a  large collection of data
 
Accessing database from JSP
Accessing database from JSP Accessing database... going to discuss the connectivity from MYSQL database with JSP.we take a example of Books database. This database contains a table named books_details. This table
 
Session Related Interview Questions
what is session,what is session tracking,session tracking,Session Related Interview Questions Session Related Interview Questions... be implemented by: a) Persisting the session into database b) Storing the session in-memory
 
Drop Table in Database
database. Understand with Example The Tutorial illustrates an example from Drop Table in Database. In this tutorial we show you a table created in database... Drop Table in Database Drop Table in Database
 
Database books
Database books Database books... in Relational Database Management Systems (RDBMS). SQL provides commands through... for developing client/server database applications.      
 
SQL Database Analyst
Schema, Database, designer, asp, xml  Contact Information: Email... SQL Database Analyst SQL Database Analyst...; Position Vacant: SQL Database Analyst Job Description 
 
Backing Up and Restoring A MySQL Database
; This tutorial explains the how to backup and restore the MySQL Database... In this tutorial you learned how to take the backup of your MySQL Database... Backup MySQL,MySQL Backup,Backing Up and Restoring A MySQL Database
 
Open Source Database
, but a flood of database-, BI- and data-center-related news coming out of LinuxWorld... Open Source Database Open Source Database Open Source Database Benchmark
 
Jdbc access database
Jdbc access database Jdbc access database... is a Java Database Connectivity. The JDBC Connectivity provides API classes and interfaces for connecting the front end in Java application with database
 
Setting up MySQL Database and Tables
MySQL Database Setup,MySQL Hibernate,Hibernate MySQL,Hibernate MySQL Tomcat Setting up MySQL Database and Tables...; I am assuming that you have running instance of MySQL Database and you know
 
JDBC, JDBC Tutorial, JDBC Tutorials
to manipulate data stored into the database. Here is the complete tutorial on JDBC... operation. Tables in a database can be related to each other with keys... JDBC - Java Database Connectivity Tutorials JDBC
 
Update Records in Database
record in database. In this Tutorial, the code run a select query to retrieve... Update Records in Database Update Records in Database         
 
PHP Mysql Database Connection
with Example The Tutorial illustrate an example from PHP Mysql Database Connection... PHP Mysql Database Connection PHP Mysql Database...;    PHP Mysql Database Connection is used to build
 
Open Source Java Database
Open Source Java Database Open Source Java Database An Open Source Java Database One$DB is an Open Source version of Daffodil DB, our commercial Java Database. One$DB is a standards based (JDBC 3.0 and SQL
 
Database books Page11
Database books Page11 Database books Page11... by the Open ServerConnect and Open ClientConnect programs and related products. For each... Java Database Connectivity (JDBC) from the Java Software Division of Sun
 
To Upload and insert the CSV file into Database
To Upload and insert the CSV file into Database To Upload and insert the CSV file into Database   ...; In this tutorial, you will learn how to upload a CSV file through JSP and insert
 
Select data from Table in Database
Select data from Table in Database Select data from Table in Database       ... to retrieve the selected data from table in database. The select query in the database
 
Database books Page1
Database books Page1 Database books Page1...; The SQL Tutorial The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL
 
Eclipse Plunging-Database
Eclipse Plunging-Database Eclipse Plunging-Database... common tasks such as browsing schemas, altering database objects, and working... database to a DB2 database.         
 
Backing Up and Restoring A MySQL Database
; This tutorial explains the how to backup and restore the MySQL Database...; accounts.sql In this tutorial you learned how to take the backup of your MySQL Database... Backup MySQL,MySQL Backup,Backing Up and Restoring A MySQL Database
 
Using MYSQL Database with JSP & Servlets.
a database named "mysqltutorial" for our tutorial. create... to create tables for our tutorial. To connect to a database "use <... Using MYSQL Database with JSP & Servlets. Using
 
Database Designing
Database Designing Database Designing...; There are some rules are available for designing the database... multiple value store  and singular column names . MySQL Database Normalization
 
Adding a New Column Name in Database Table
Name in Database Table Adding a New Column Name in Database Table          ...;    In this jdbc tutorial program we are going
 
Connecting to MySQL database and retrieving and displaying data in JSP page
; This tutorial shows you how to connect to MySQL database and retrieve... MySQL JSP,JSP Example,MySqL JDBC,Connecting to MySQL database and retrieving and displaying data in JSP page Connecting to MySQL database
 
Quartz Tutorial
Quartz Tutorial, Quartz Scheduler, Quartz Job Scheduler Quartz Tutorial        ...;      In this Quartz Tutorial you will how
 
Quartz Tutorial
Quartz Tutorial, Quartz Scheduler, Quartz Job Scheduler Quartz Tutorial        ...;      In this Quartz Tutorial you will how
 
Setup MySQL Database
Setup MySQL,Setup MySQL Database Setup MySQL Database...;     In this section we will create database and table into MySQL database. Table created here will be used in sample application
 
Designing Database
Designing Database Designing Database...; Database designing is considered as crucial stage in the development lifecycle of the web application. The database is finally responsible for storing
 
Designing Database
Designing Database Designing Database...; Database designing is considered as crucial stage in the development lifecycle of the web application. The database is finally responsible for storing
 
Accessing Database from servlets through JDBC!
of all download the source code and database used in this tutorial... Accessing Database from servlets through JDBC... how to access database from servlets. Here I am assuming that you
 
Database Specialist
Database Specialist Database Specialist...; Position Vacant: Database Specialist (PHP/MySQL)  Job....  Candidate is required to build database-driven web applications
 
Retrieve image from database using Servlet
Retrieve image from database using Servlet Retrieve image from database using Servlet      ... you how to develop a Servlet that connects to the MySQL database and retrieves
 
Relational Database Concepts
dimensional structure used to hold related information. A database consists of one... Relational Database Concepts Relational Database.... Here comes the concept of databases. What is database? A database
 
Database Management System (DBMS)
Database,Database Tutorials Database Management System (DBMS) A Database Management System (DBMS) sometimes called a database manager or database system is a set of computer programs that controls
 
J2EE Tutorial - Introduction
J2EE Tutorial - Introduction J2EE Tutorial... want to know whether J2EE is Java atall or something else. This tutorial... (ie) DataBase access!) The title of the book was  appropriate
 
Delete a Records in Database
an example to delete Records in Database. In this Tutorial, we create a table country... Delete a Records in Database Delete a Records in Database         
 
Database books Page8
Database books Page8 Database books Page8... sources, including SQL Server or any database that can be accessed by a Direct... to another database. A CSA uses standard CICS services to perform its processing
 
Inserting Image in a database Table
JDBC Insert Image Example,Storing Images in MySql Database,Inserting Image in Database Using Servlet Inserting Image in MySql Database Table         
 
Database books Page20
database. It is assumed that users of this tutorial are proficient in working... Database books Page20 Database books Page20... and input XML into a database. Gets the XML document by fetching the maximum number
 
Creating a Database in MySQL
Creating a Database in MySQL,JBC Create Database,Create Database in Java Creating a Database in MySQL   ... establishing the connection with MySQL database by using the JDBC driver, you
 
Database books Page18
Database books Page18 Database books Page18...;         MySQL basic tutorial This MySQL tutorial is a guide for new MySQL users, providing a reference
 
Mysql Loader Tutorial
Mysql Loader Tutorial Mysql Loader Tutorial...; Mysql Loaded Tutorial is used to import a data to a plain text from Mysql database. The Plain Text is used as backup file from which the data is again
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.