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?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown