Please check the following Microsoft solution. May be helpful for you. http://support.microsoft.com/kb/305995
Regards, Mudassar Ramzan ----- Original Message ----- From: Fabio Lemos To: excel-macros@googlegroups.com Sent: Tuesday, May 19, 2009 5:33 PM Subject: $$Excel-Macros$$ Re: Run Time Error 3050 - Could Not Lock File - ERROR? It could be the access registry lock in access. You should use a less conservative lock. Fabio L. Lemos Em 19/05/2009, às 08:30, Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com> escreveu: Hi All, Does anyone know why this error occurs? I am using DAO in a Excel Userform to save data in MS Access. Approx 40 users are using the userform and its working fine however sometimes it shows following error message and crashes: Run Time Error 3050 - Could Not Lock File What could be the reason? Regards, Alokeshwar _________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." ---------------------------------------------------------------------------- Explore and discover exciting holidays and getaways with Yahoo! India Travel Click here! --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---