The only other possibility is that the new users have their default database open mode set to exclusive. Both original and new users all have the same NTFS permissions to the database and folders on the network. Get 1:1 Help Now Advertise Here Enjoyed your answer? Connect with top rated Experts 9 Experts available now in Live! navigate here
And I dont have the right to complain about it. Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 24 Any suggestions would be appreciated. Beantown Boy Please use [highlight=vb]your code goes in here[/highlight] tags when posting code.
Sat, 10/02/2010 - 18:39| jack5465 This error occurs when the .ldb file is not automatically deleted when the user closes MS Access. Please try again later. All rights reserved. Expert Database Programming MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0) Reply With Quote 12-03-08,21:07 #4 myle View Profile View Forum Posts Visit Homepage (Making Your Life Easy)
If I go into the folder and double click on the database.mdb file, I get a message that says that I dont have enough permissions to use the object , however I am quiet confused, anything else I should do? regards glisando glisando, Jul 10, 2007 #9 dfriend846 Thread Starter Joined: Aug 11, 2005 Messages: 203 Hello Glisandro, Unfortunately I was able to answer my initial question but I do Ldb File Further if either of the 2 new users log on first, any of the original users can use the database but only as read-only.
Only the back-end should be on the server: each user shoud have his/her own copy of the front-end, ideally on his/her hard drive. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next.
Avikash Nadan 155,863 views 5:27 2.27 Creating a Multi User Login System in Access VBA - Duration: 4:40. Microsoft Access Record-locking Information Also if using a custom workgroup file, it must not be the same name as the database (ie. However I read in the Ms Access 2003 bible that I have to go to Tools, Security, User and Group Accounts to to add users, however I face a problem. Sign in to make your opinion count.
Originally Posted by SeanK Have you ever known of any kind of change taking place in a Windows environment that didn't require a reboot? http://www.utteraccess.com/forum/index.php?showtopic=1602560 Stoney Brooks 6,608 views 3:50 Hide database window, Hide menu, Disable shortcut menu, Disable Special Keys : MS Access - Duration: 8:10. Could Not Lock File. 3050 Sign in to report inappropriate content. Access Lock File The time now is 11:00 PM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored
If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. check over here Forgot your password? Each should still have their own copy? Please Wait... Open Databases By Using Record-level Locking
In my 2005 note I referred to the Write priveleges of the folder on the network. Also, with 100+ users all trying to create/lock the same file in the same location you will inevitably run into locking violations. Have you ever known of any kind of change taking place in a Windows environment that didn't require a reboot? http://sinistro.org/lock-file/could-not-lock-file-error-access.html Always Listening To: Thrice Reply With Quote Nov 3rd, 2005,10:20 AM #3 The_Grudge View Profile View Forum Posts Thread Starter Fanatic Member Join Date Jan 2005 Location Canada Posts 810 Re:
Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? JonAWF 9,067 views 3:44 How to Unlock Microsoft Office Access Record-locking Information - Duration: 0:46. austin72406 7,010 views 12:34 Microsft Access Tutorial: Record Locking Options - Duration: 3:05.
Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Always Listening To: Thrice Reply With Quote Nov 3rd, 2005,12:42 PM #5 SeanK View Profile View Forum Posts Frenzied Member Join Date May 2002 Location Boston MA Posts 1,160 Re: Microsoft Results 1 to 4 of 4 Thread: "Could not lock file" error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch Show more Language: English Content location: United States Restricted Mode: Off History Help Loading...
In the general Tab, there is an option called 'add'. www.google.com - Pay Tribute. Advertisements do not imply our endorsement of that product or service. http://sinistro.org/lock-file/could-not-lock-file-error-ms-access.html Related Content Blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures in SQL Server 2005 PhpBB3: Access to the Administration Control Panel is not allowed as you do not have
Up next 57. None of the other dozen plus users have a problem. EnvironmentTableau DesktopMicrosoft Access ResolutionThis error is not specific to Tableau, and it has no single resolution. If you're not already familiar with forums, watch our Welcome Guide to get started.
You may have to register before you can post: click the register link above to proceed. When one of the users opens the file (the others haven't tried yet) she gets the following error pop up... "Could not lock file". Make sure the user that need to access the database have all modify, read and execute, read and write rights for the current folder. Stay logged in Sign up now!