Row level locking!!

[johnyjassi]

Hi Guys,

i am facing a big problem here. 5 users are using the database through access forms. When any one of them try to update a previously created record and click on save button it shows some msg window asking about save record or save to clipboard. click on save to clipboard, it doesn't save the changes and when click on save record it shows some error and application crashes. it askes for repair next time it is open and ends with application corruption. Is there any solution that when any user wants to make changes in and save it he should be able to without showing error. Like i can do it in my test database and it works. Any suggestions are welcomed and appreciated.

Thanks

 

[RuralGuy]

Is your application split to FrontEnd and BackEnd? Does everyone have their own copy of the FrontEnd? http://allenbrowne.com/ser-01.html

 

[johnyjassi]

Hi thanks for reply, Yes my application is split, but both are in same folder. I put the application in a network drive and all the user has shortcut to the application on their desktop.(Is it how it should be?) Please correct me if i am wrong.

 

[georgedwilkinson]

No, they all need to have their own copy. They should copy the FE to their local PC. Use Bob's FE updating tool if you need it. I don't have the link right now.

 

[johnyjassi]

I got it, and tried with two users and it works well. I copied th FE to their desktop as the database is split so the BE is same. Thanks for your advice.

 

[georgedwilkinson]

Oh, glad we could help. I always learn a lot from RG.

Here's the link to Bob's front end updating tool:
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

 

[johnyjassi]

WOW! this is great, now I don't have to worry about to update the front end as I make changes in it. I don't have to go to each user to replace it with the new copy. Thanks as lot!!!!

 

[georgedwilkinson]

It's the little things in life that give so much pleasure.

Glad to help.

 

[RuralGuy]

Thanks for jumping in while I was off line George. It got Johny going quicker.