asked on

HOw to multi user application ising VB6 and acess

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)

[ fanpages ]

Hi,

Please note my comment regarding soft-locking in this PAQ:

"Lock Record"
[ https://www.experts-exchange.com/questions/21394336/Lock-Record.html ]

You could apply "soft locking", that is, have an additional column, say "Locked", that you would set to 'True' (or 'Y', or whatever) upon first usage, and reset to 'False' ('N' etc) when the use of the record was concluded (i.e. unlocked).

All users would query this "Locked" column on each record before usage, and if set to 'True' ('Y' etc), then would report that the record was locked.

BFN,

fp.

PS. Same question as...
[ https://www.experts-exchange.com/questions/21882773/how-to-use-lock-in-vb6-application-using-acess.html ]

?

ASKER CERTIFIED SOLUTION

dancebert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

[ fanpages ]

I still believe the two questions combined violate an E-E rule of offering more than 500 points per question.