I've tried this code to create a vFpro tabe but nothing happened

I tried the code I produced(below) to create a free standing foxpro table, as I am not using a .dbc. It doesnt fall over, it runs straight through asthough it works, yet creates nothing in the directory atall? Please help!!!!!!!

Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim lngRecsAff As Long

I just wanted to point out that you don't necessarily need to spell out completely the data type when creating a table in VFP.
It ends up only reading the first letter of whatever you type. But, if you want to continue to do it for yoyr readability, just know that the letters past the first are ignored.

I generally setup the first few lines you show to create that first table, tab1.dbf.

I used a slightly different connection string where I pointed to a folder location I knew existed. I then executed the sequence right through where the Execute occurs to create that tab1.dbf file. It succeeded.

I then went back and put in your part where you tell where you want the table created, "SourceDB=c:\New Databases\newDB\;", and I know for a fact this path with these folders do not exist in an way, shape, or form on my hard drive. I executed the table creation code and no error was thrown at all. As far as it looked, everything ran fine. Then I went to see where it put that table that it supposedly create and found it didn't create the table. And the reason was obvious to me why it didn't create the table-- it was because the path of c:\New Databases\newDB\ did not exist. ODBC is not going to create a path for you and, if it can't find it, it will do nothing legitimate because you didn't tell it to do something legitimate. As I requested earlier, please check to see if that directory actually exists on your PC. Maybe it's spelled slightly incorrectly or it flat out doesn't exist. But, I can only guess from this end. And I do know the sequence works fine if a proper drive and path that exists is used to feed the SourceDB parameter of the connection string.

I tested a slightly different configuration and the connection string seemed to have the SourceDB value ignored altogether as though it didn't exist (even though it complains if I leave it out). But at least it did successfully create the table. It just didn't do it where I asked it to do it this time.

Please verify that you didn't get your tab1.dbf written to a different location than your SourceDB location. If it didn't get written at all, please verify your SourceDB location does exist.

I had a similar problem when exporting SQL Server to a FoxPro file using DTS. Everything went fine, but no file. It turned out the file landed in my current directory (C:\Program Files\Microsoft SQL Server\80\Tools\Binn) no matter what I specified for the connection. Do a search on you machine and see if the file landed elsewhere

It almost seems to me that the SourceDB location is irrelevant if you are creating a new table. It sends it to what it considers the current and active directory. The SourceDB location is relevant if you're opening an existing database or free table, since it is pointing directly to something it can already find. Sadly, documentation on connectivity driver quirks is lacking and you end up running across these things the hard way.

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.
There is also a companion Debug Toolbar that looks like the followin…

Here are a few simple, working, games that you can use as-is or as the basis for your own games.
Tic-Tac-Toe
This is one of the simplest of all games.
The game allows for a choice of who goes first and keeps track of the number of wins for…

Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…