It may be a stupid question but I'll ask you for help:
I have a DB, split in front and back end - back end on server, front end on users PCs.
When there are two or three users the application works fine.
When there are more users some of them are receiving "Couldn't update. Record may be locked" message.
THE FORMS THAT FILL THAT DB ARE BASED ON TABLES! I'm a begginer but I suppose that is the problem. If that's the case - WHAT SHOULD I DO TO PREVENT RECORD LOCKING??? I remember reading somwhere that I should base my forms on queries instead on tables but CAN SOMEONE TELL ME HOW THIS SHOULD BE DONE.
And could there be another problem??? Because most of the time, when 2 or 3 PC are working simultaniously with a same form there is no problem (I'm thinking that if one PC opens a form and locks the tables it shold block the work on all the other PCs. But most of the time 2 - 3 PCs are working fine simultaniously?!?!?!).
I'LL BE EXTREMELY GRAITFULL IF SOMEONE CAN HELP ME!