>Joe,
>MSFT is supposedly working on a true OLEDB provider for VFP. ADOX has built in functionality to create tables, but you need a true OLE DB provider, not the generic ODBC driver. For example, the following code will create a VFP table with a true OLE DB provider:
>
>Dim table As New Table
>Dim catalog As New ADOX.Catalog
>
>catalog.ActiveConnection = "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=E:\DEV\VISUALMM\DATA"
> catalog.open
> table.Name = "MyTable"
> table.Columns.Append "Column1", adInteger
> table.Columns.Append "Column2", adInteger
> table.Columns.Append "Column3", adVarWChar, 50
>
> catalog.tables.append tbl ' OK for OLEDB-Will generate error w/ODBC driver
>
>>Anyone programmaticly created a foxpro table using VB? I could use some pointers. :)
>>
>>My Humble thanks in advance.
Which referance object under project defines "Table"? How would I know if I have the true OLE DB driver. If I dont have it where would I get it from.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams