Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CREATE ACCESS DATABASE/TABLES USING ADO
- Thread starter NW
- Start date
MichaelRed
Programmer
I'm not aware of any capability, current OR PLANNED for the vreation of a complete MDB file from ANY data access processes (e.g. ""SQL"
. If this is a 'typo' and you mean TABLE within an existing (and defined) database, I know of no reasson this cannot be done with existing tools.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
. If this is a 'typo' and you mean TABLE within an existing (and defined) database, I know of no reasson this cannot be done with existing tools.MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
Unless I'm off base on the question, I agree (in part) with Michael, it SHOULD be possible to create an .mdb using current data providers jet and SQL server. Also using the ADO Object (not ADO control). Once the .mdb is created with ADOCreateDatabase(), ADOCreateTable()could be used to create table properties. However, I don't think the process would be for the faint of heart...
The following might be a start in the right direction??
Sub ADOCreateDatabase()
Dim catName As New ADOX.Catalog
catName.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=.\New.mdb;"
End Sub
The following might be a start in the right direction??
Sub ADOCreateDatabase()
Dim catName As New ADOX.Catalog
catName.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=.\New.mdb;"
End Sub
- Thread starter
- #5
- Status
