>I am using Visual FoxPro 9.0 SP1 to update MS Access tables within a database. I have to setup manually the ODBC connection. Is there a way to set up the ODBC connection automatically within VFP code?

It depends on how you're using ODBC connection. A DSN-less connection could be used for SPT. You can also check ODBC DSN Class File #9749