Code for configuring ODBC Data Source Administrator

[baltman]

I am trying to write some code for FoxPro to automatically import data from MS Access for a report. I have the following 2 lines of code which work great for the Northwind Database:

******
CREATE SQL VIEW "Remotetest" REMOTE CONNECT;
"MS Access Database" AS SELECT * FROM Employees

sele * from Remotetest into cursor tempdata
******

My problem is that I cannot figure out how to "configure" the "MS Access Database" by "Select"ing databases with code so that my users don't have to use the ODBC control panel. It seems that this should be doable with one or two lines of code....

In other words, what code do I need to point to an "MDB" other than Northwind?

Thanks in advance!

Brian