>>>>I have created fox free tables in VB but not Database files with tables. Anyone have some ADO code for this?
>>>
>>I am in need of a little more help.
>>
>>My humble thanks in advance,
>
>Joe,
>
>This is sample code that creates a free table:
>Dim oc As ADODB.Connection
>Set oc = New ADODB.Connection
>oc.Open "file name=testalter.udl"
>oc.execute "create table testcreate (single c(10))"
>oc.close
>Where testalter.udl contains the following connection string:
>
>DSN=TestAlter;UID=;SourceDB=d:\temp;SourceType=DBF;Exclusive=Yes;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
>
>And the 'TestAlter' DSN uses the Visual FoxPro ODBC driver and points to a free table directory. You can do this a number of different ways, for example with ADOX too.
This is almost identicle to the code I use. What I need to be able to do is create a database container. My thoughts are that the
SourceType=DBC; is a major part of the puzzle, I just don't know how to put it all together. To create a database with tables (non free).
Any help would be a great boon,
~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