Is it better to add the view to the database at development then when the application goes out send out a new database, or write the view in code and run it each time the form is run.

John

>Hi John,
>
>>>>>How about parameterised views and a requery of each view as the customer changes.
>
>I would use the method Caroline describes. It's very reliable--we've had no issues with the DBC. We use free tables as well. We open the tables through code, so the DBC knows nothing of paths, only the alias.
>I think the updating of tables is more robust because the cursors are disconnected, and updated through USE AGAIN type access.