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