Create MDB database by VBS (ADO/DAO), new MDB file
ActiveX RegEdit.   ActiveX User account Manager   Pure-ASP Upload
Export MDB/DBF from ASP   Active LogFile   WebChecker   ActiveX/ASP Multi Dictionary object
 See 
 also 		  IISTracer, real-time IIS monitor and logging tool.
 Huge ASP file upload with progress bar. 


Do you like this article?
Please, rate it
and write review!
Rated:
by Aspin.com users
What do you think?
 Top messages
 4.5.2002 9:16:43 
 Send an email from ASP (WSH) using VBSscript, CDONTS and Outlook. (nbsp;ASP / ASP.Net, WSH, VBScript, Email)
 22.3.2003 19:18:41 
 Read and write SQL image data, store binary file to sql table. (nbsp;WSH, Database, Conversion, VBScript)
 26.1.2007 13:57:34 
 ASP image resize and jpg/gif/png convert, free VBScript code (nbsp;ASP / ASP.Net, VBScript)

 Create MDB database by VBS (ADO/DAO), new MDB file 

 Areas>Languages>VBScript
 Areas>ASP / ASP.Net>Functions
 Areas>ASP / ASP.Net>Database>Data access>OLEDB>JetOLEDB
 Areas>ASP / ASP.Net>Database>Data access>DAO
 Areas>ASP / ASP.Net>Database>MDB
There are (at least) two ways how to create MDB database from VBS.

1. Create MDB by ADO (ADOX)

At least MDAC2.0 installed is required to run next code. 
Const Jet10 = 1
Const Jet11 = 2
Const Jet20 = 3
Const Jet3x = 4
Const Jet4x = 5

Sub CreateNewMDB(FileName, Format)
  Dim Catalog
  Set Catalog = CreateObject("ADOX.Catalog")
  Catalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
     "Jet OLEDB:Engine Type=" & Format & _
    ";Data Source=" & FileName
End Sub

'Create Access2000 database
CreateNewMDB "G:\a2000.mdb", Jet4x

1. Create MDB by DAO

DAO 3.6 is required to run the code (You can also use other version of DAO, for example DAO.DBEngine.35) 
Const dbVersion10 = 1
Const dbVersion11 = 8
Const dbVersion20 = 16
Const dbVersion30 = 32
Const dbVersion40 = 64
Sub CreateNewMDB(FileName, Format)
  Dim Engine 
  Set Engine = CreateObject("DAO.DBEngine.36")
  Engine.CreateDatabase FileName, ";LANGID=0x0409;CP=1252;COUNTRY=0", Format
End Sub

'Create Access2000 database
CreateNewMDB "G:\a2000.mdb", dbVersion40
 
 

See also for 'Create MDB database by VBS (ADO/DAO), new MDB file' 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.

If you like this page, please include next link on your pages: 
<A
 Href="http://www.motobit.com/tips/detpg_createmdb/"
 Title="The article contains information about creating
  database from ASP/VBS."
>Create MDB database by VBS (ADO/DAO), new MDB file</A>
     IISTracer - IIS ISAPI real-time monitor IISTracer is a real-time monitoring tool for Microsoft IIS, which will show/log you what is happenning on IIS server right now. It let's you reveal problems with long-running scripts (.asp, .cgi, cfm...), hang-up states and low resource situations and lets you stop long-running requests (uploads/downloads).      ActiveX User account Manager - Set of simple objects for creating, deleting, and managing user accounts, groups, servers and domains in the Windows NT environment.
     Active log file - Hi-performance text file logging for ASP/VBS/VBA applications. Lets you create daily/weekly/monthly log files with variable number of logged values and extra timing and performance info.      ActiveX windows registry editor - Intuitive, easy to use COM interface to windows registry. Set of classes to read/enumerate/modify windows registry keys and values from ASP, VBS and T-SQL.
     ActiveX/ASP Multi Dictionary object - Free-threaded hi-speed dictionary algorithm with unique/nonunique keys (map/multimap). Connect to another dictionary object in the same process. Lock and Unlock methods to synchronize tasks (application scope). Share ASP Application/Session objects.      Export DBF/MDB from ASP - Conversion from recordset to MDB/DBF. Direct binary output of MDB or DBF files from ASP pages with one row of code.
     Pure-ASP upload - lets you upload files using Pure ASP VBS code (using multipart/form-data and input type=file).      ByteArray - Works with safearray binary data (VT_UI1 | VT_ARRAY) - save/restore binary data from disk, find, work with code pages, convert to string/hexstring(SQL).
     WebChecker - Checks http, https, ftp and gopher internet connections in regular intervals. Lets you monitor web site functionality (uptime). Enables restart or notification on problems.      HTTPLog ISAPI filter - Lets you log incomming/outgoing http header and document data to separate files. Monitor of IIS service input/output.
© 1996 – 2008 Antonin Foller, PSTRUH Software, e-mail help@pstruh.cz