Or you could use SQLSTRINGCONNECT() rather than relying on the existence of a DSN.

---

>>Hi,
>>
>>I have a visual foxpro system which is connected to "Access" database, but it cannot be run at another computers after i finished the system installation with distributed setup disk, and it is because of cannot find the "DSN" at those computers and cannot build the connection.
>>
>>So, what can i do now, do i need to create a "DSN" programatically in the system.
>>
>>Thanks for your help.
>>
>>Aston
>
>There is a class in the Files section named ODBC DSN Class [non-visual] that may help you.