Compact (compress) mdb database from ASP/VBS script.MOTOBIT.COM

Other articles:

Base64 encode VBS function (vb encoder algorithm), source code (Conversion, VBScript)

Base64 decode VBS function (vb decoder algorithm), source code (http, Conversion, VBScript)

Download multiple files in one http request (File & data transfer, VBScript)

Areas > Languages > VBScript
Areas > ASP / ASP.Net > Database > Data access > JRO
Areas > ASP / ASP.Net > Database > Data access > DAO

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.

Copyright and use this code

The source code on this page and other samples at https://www.motobit.com/tips/ are a free code, you can use it as you want: copy it, modify it, use it in your products, ...

If you use this code, please:

1. Leave the author note in the source.

2. Link this sample from you page.

<A
 Href="https://www.motobit.com/tips/detpg_CompactMDB/"
 Title="Two ways to compact MDB database
	(by DAO and JRO) from
	ASP/VBS script."
>Compact (compress) mdb database from ASP/VBS script.</A>

Do you like it? Rate me on LinkedIn

Motobit.com

Compact (compress) mdb database from ASP/VBS script.MOTOBIT.COM

See also

Copyright and use this code