Vincent Teachout wrote on 2012-09-19:
> I do have the MS Access ODBC on my computer, and I can use that to
> create an MDB just fine using the connection wizard. I was just
> wondering what commands were behind the connection wizard, and was
> hoping I could use them to create an MDB on the fly.
>
> Thank you, though!
>
Vincent,
LOCAL adox as ADOX.Catalog, tble as ADOX.Table
adox = CREATEOBJECT("adox.catalog")
tble = CREATEOBJECT("adox.table")
* Create the container
adox.create("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data
Source=c:\temp\test.mdb;")
* make sure the container is active
adox.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine
Type=5;Data Source=c:\temp\test.mdb;"
* Create the table
tble.Name = "Prospects"
tble.Columns.Append("Name")
tble.Columns.Append("Company")
tble.Columns.Append("Phone")
tble.Columns.Append("Address")
* Append it to the container
adox.Tables.Append(tble)
Some useful information:
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=1089
http://www.pcreview.co.uk/forums/create-mdb-dataset-and-adox-t2452708.html
http://msdn.microsoft.com/en-us/library/windows/desktop/ms675318(v=vs.85).as
px
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
