Unsubscribe
Mark Gancevich Facilities & Systems Manager Centra Industries Inc., PCC Aerostructures [email protected] 519-650-2828 x223 -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: Wednesday, September 19, 2012 12:42 PM To: [email protected] Subject: RE: VFP - Programattically create MDB container file? 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 [excessive quoting removed by server] _______________________________________________ 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/4335938503631e418597deb8941bbcc309c1a2c...@sea.cas.centra-ind.com ** 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.
