|
VBS functions to create MDB database from VBS using Jet engine and ADOX or DAO. Supports all MDB database formats. Author: Antonin Foller Code: ASP 2.0 & VBScript |
| |
Overall Rating:
 User
Rated
| |
Quick Fix to implement a "small-scale" database
Written by Anonymous User (#1193-76) from Philadelphia, PA (Saturday, September 13, 2008)
 |
Strengths: flexible COM object, ADOX vs FSO
Weaknesses: only used for "small-scale" solutions
Details: This tidbit from ASPIN.com is perfect to create fairly large text files that MAY need to implement relational database properties instead of a "single" flat file.
Thus, once you create an ".mdb", relational tables can be implemented. Subsequently, indexes, keys, variable types & other properties may be implemented within an ".mdb".
In addition, once an (.mdb) is created, it can be used by a "MYRIAD" of other client applications, NOT just Microsoft, but any application(s) having availability of ODBC drivers.
It offers more power than reading and/or writing FSO objects.
Review Based On: 1 Hour(s) of usage |
Good Job
Written by Anonymous User (#1687-293) from USA (Wednesday, March 02, 2005)
|
Strengths: Easy code, easily found, easily used as is.
Weaknesses: no comment
Details: Immediately used in my code that compiled with no complaints.
Review Based On: 1 Hour(s) of usage |
Create MDB by ADO (ADOX) 
Written by Anonymous User (#1642-304) from UK (Sunday, February 15, 2004)
|
Strengths: Short; Pertinant; Clear; It Works
Weaknesses: English tense and grammar could have been reviewed; links could have been given
Details: At least MDAC2.0 installed is required to run next code.
At least MDAC2.0 installed is required to run >the following< code.
--------------------------------------
DAO 3.6 is required to run the code (You can also use other version of DAO, for example DAO.DBEngine.35)
DAO 3.6 obtainable - from where
DAO.DBEngine.35 - presumably DAO 3.6 - from where
Review Based On: 1 Hour(s) of usage |
| |
|
