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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to