You would want to use SQLSTRINGCIONNECT() in this case. To get connection string, use ODBC Manager to create FILE DSN with options you want, open it in any text editor and copy it's contents into connection string.



>Hi everybody,
>
>can somebody show me the way to connect to a Access .MDB file?
>I want to set the properties for the ODBC connection via Foxpro Code.
>(For example; the target .MDB file)
>
>I hope somebody helps me out!
>
>Cheers,
>
>Erwin