Michael,
It looks to me like you're somewhere in between a DSN-less connection and creating the data source on the fly. You could try connecting to Access using SQLSTRINGCONNECT() passing the connection string. I'm not sure, though, whether Access supports DSN-less connections. You could also use SqlConfigDataSource to create your own DSN. Take a look at
http://support.microsoft.com/support/kb/articles/q142/2/16.asp for details on how to do this. In addition to what's mentioned in the article you may want to go to the ODBC control panel and create a file DSN with the options you want. You can then look at the file to see what the name of each parameter is. For example, you should use DBQ=F:\projects\accountg\data\printing\infortext.mdb to tell Access what database you want to use.
>I'm trying to create a DSN-Less connection from VFP6 to Access tables.
>
>Here's what I have so far, but my connect string is clearly wrong:
>
>ConnectString ="Driver=Microsoft Access Driver;Backgroundfetch=Yes;Collate=Machine;Exclusive=No;SourceType=MDB;SourceFile=F:\projects\accountg\data\printing\infortext.mdb"
>
>declare integer SQLConfigDataSource in odbccp32 Integer, Integer, String, String
>
>lnSuccess=SQLConfigDataSource(0,1,"Microsoft Access Driver",ConnectString)
>
>What have I done wrong? Also, how will I refer to the 'table' via SQL?
>
>TIA