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)
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.
for 'Compact (compress) mdb database from ASP/VBS script.' articleOpen MDB files on remote computer in ASPTwo ways to open DSN-less connection to MDB file on remote computer from ASP/VBS script.
Convert MDB database to another format (JET, access version)How to convert Access database from one format to another format from ASP/VBS script.
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>
© 1996 - 2014 Antonin Foller, Motobit Software | About, Contacts | (Find us on Google+)