Hi John, thanks for the reply.

>...you can include a "views" dbc inside your app which means each user is using their own copy => no dbc contentions and no problems with dbc versioning etc,.

This is a great idea. I already have a 'views' dbc for my application, but the dbc/dcx/dct files are distributed to each workstation along with the .exe file. It never occurred to me that the database container could be wrapped-up into the .exe file. I guess I'll have to check all my code first to ensure that DBSETPROP() is never called.

>... and if you use SQLStringConnect() for your connstring, you don't need to set up odbc datasources on user machines any more.

This is a good idea too, but will mean a lot of refactoring of existing code. I'll try and introduce it when time permits (which it rarely does!)


Regards,
Alan