Hi Guys,
I'm having a problem with my program. I created a program that uses remote views to connect to a SQL 2000 Database. The remote views are stored under rmviews.dbc file which is stored in the server.
Upon loading, the program will verify if there are changes made to the remote views then it will copy the files into the client machine. The program will then use the remote views in the local drive to access the database in the server. I do this to prevent locking of the dbc files, because the program is used by 50 or more concurrent users.
The problem is, the error no. 1709 (Database Object is being used by someone else) still appears on some cases.
What will be the best way to trap this error?
Thanks in advance...
P.S.
I use shared connection on my remote views that I specify in the load event of my forms.
use rmviews!datacenter in 0 nodata alias datacenter connstring StrConn
use rmviews!customerperdcno in 0 nodata alias customer connstring StrConn
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.