multiuser database updates using sql server and VB6
Posted on 2001-06-30
I have created a database in sql server 7, and writing a program in vb6 as the frontend. I am using a dataenvironment and sqloledb driver to connect to the database.
When testing the multiuser capability, and different users update the database, they are not seeing the updates of each other. I am using a server side and I have tried setting the database cursor to Dynamic, but it reverts to static. Please help??