" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Create,Compact/Compress and Convert MDB database using ASP/VBScript

Posted on November 23rd, 2015 by Tapaswini Mohanty

There are two ways to create MDB database using VBScript. 1. Create MDB by ADO (ADOX): The following code is for creating a new Access2000 database by ADO and for the code to execute MDAC2.0 is required to be installed in the machine. const jet4x = 5 DoCreateNewMDB “F:\MyAccessDB2000.MDB”, Jet4x Sub DoCreateNewMDB(FileName, Format) Dim Catalog […]

Creating new WorkGroup in Access 2007

Posted on November 23rd, 2015 by Shibani Shubhadarshini

The creation of workgroup in Access 2007 is different from how it is usually done in Access 2000 and Access 2002-2003. The steps to follow for creating WorkGroup are: Open a DB in Access or enable macros in existing DB. Open Create tab, go to Other group select Macro and click on Macro in drop […]