Create Table problem

[princessk1]

Hello,

I am trying to add a table through my VB application to a FoxPro database. The table is being created in the same folder as my VB application and not in the database specified by the connection.

On the msdn microsoft help site, it states that 'Tables created in the Visual FoxPro OLE DB Provider using CREATE TABLE are placed in the default folder of the calling application, unless you specify another location'.

Does anyone know how to specify another location?

Thanks!

 

[rgbean]

It should be as simple as providing a full path name for the table. e.g. instead of
CREATE TABLE Mytable ...
use
CREATE TABLE c:\mydir\Mytable ...

Don't forget quotes if there are any embedded spaces in the path.

Rick