Hello,

I am running a real time system and the VB program tries to update a record and fails due to some other process locks that record(MS SQL Server replication process)

The VB Program uses ADO objects and it fails when it tries to open a recordset using
rs.open (SQL, Connection, Type, LockOptimistic)

IS there any way I can force the program to wait until rs.open executes.
The program not supposed to jump to the error trapping

thanks in advance
Masanam

Change the timeout value for your connection object i.e.

cn.Properties("Connect Timeout").Value = TIMEOUT_CONNECT
cn.Properties("General Timeout").Value = TIMEOUT_COMMAND
cn.ConnectionTimeout = TIMEOUT_CONNECT