I am working in an Vb6 application and Access as database.
NOw I want to make this application multiuser application.
That means My database will be on one machine and the application will be on one or more than one machine and it will use the same database.
Now I want to do that if any user doing any changes in any record then I want to show other user a msg saying Record is in use and so that second user cannot do any thing with that until the first user finishes his work on that record.
And also how to know that is there any transction runnging or not.
And othet multiuser feature ( as i donot know all multiuser featers)