Hiya Gary, Ed ---

Ditto.....the sp idea is a great one, Ed.

I have never even thought about using one DSN for multiple databases.

>I always forget about that. But does it really happen on the fly, or does VFP drop the connection, change the DB, and then reconnect? That could be a bit of a performance hit. You're absolutely right about the stored procedure. In fact, it's probably the best solution (IMHO) speed wise.
>
>>DBSETPROP() can be used to change connection.database property on fly, so it's possible to reach different databases using the same DSN. Also, it's possible (i guess) to call back-end stored procedure which will access diferent databases.