Mysql – Concurrency question

concurrencyms accessMySQL

I have a MySql (5.5) database with a MS Access frontend. If two users are viewing the same record at the same time how can I make each user aware of each other? For example how would I go about displaying a label indicating that another user is also viewing the same record?

Best Answer

I may be wrong, but I don't think this is possible unless you restrict access to the data to be via stored procedures - then the procedure can trigger audit mechanism that you can expose to the users. You would also need polling of the audit if both users need to be aware.

Related Solutions

Mysql – Loyalty reward – record for every day of a week

Maybe.

SELECT count(distinct date(time_they_logged_in)) 
FROM `users` 
WHERE `users`.`time_they_logged_in` between now()-interval 7 day and now();

If the count is 7 they logged in at least once per day in the past week.

Mysql – MS Access / MySQL: unlock locked Records

I finally could fix my problem by adding a field named TIMESTAMP of type timestamp and default value CURRENT_TIMESTAMP and attribute = on update CURRENT_TIMESTAMP. Then i updated all records and set TIMESTAMP=NOW().

For now i did not get any error again.

Best Answer

Related Solutions

Mysql – Loyalty reward – record for every day of a week

Mysql – MS Access / MySQL: unlock locked Records

Related Question