Can some one please help me how to sove the following.
I have applications updating an Access database. One VB 6.0 app Second one is MS SQL Server using replication process.

The replication process locks a table and keep it for few sconds. In the mean time VB app. tries to lock the same table using adLockOptimistic and adOpenKeyset cursor type and VB app fails. How do I force VB app to wait until the lock is released.

Thanks for your help