Using a remote view - only one person can use it at a time - so if you are sharing the db, you will have this problem. A local db with the views will eliminate that problem.

-w-

>Hi Folks!
>
>Today I got another boring Problem.
>Im my APP, I use Views mixed with SQL Pass through. The Views and the SQL pass through Connections all shared. Now sometimes I got an ODBC Error:
>
>Original in German:
>Datenbankfehler 0: [Microsoft][ODBC SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt
>
>I Try to translate:
>Databaseerror 0: [Microsoft][ODBC SQL Server Driver] Connection is used by another hstmt.
>
>What is this?