However we seem to have a problem on Windows 7 workstations. Write easy VBA Code. Thread Tools Rate Thread Display Modes 03-23-2011, 06:16 PM #1 MCAS Newly Registered User Join Date: Mar 2011 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts Access MCAS View Public Profile Find More Posts by MCAS
The only other possibility is that the new users have their default database open mode set to exclusive. The .ldb file will be in the same folder as the database itself. These functions are part of the Windows API (Application Programming Interface). It doesn't sound like you're Go to Solution 2 2 2 3 Participants peter57r(2 comments) LVL 77 MS Access67 Active Directory1 Server Hardware1 Jim Dettman (Microsoft MVP/ EE MVE)(2 comments) LVL
After all, if you on your machine , logged in as administrator, then open up Access as UserX succesfully but UserY fails, then you have to conclude that the workstation O/S Sign in to make your opinion count. Add to Want to watch this again later? Connect with top rated Experts 11 Experts available now in Live!
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. Published on Mar 4, 2015Users not able to access your database? Advanced Search VBForums Visual Basic Database Development Microsoft Access "Could not lock file". Ldb File 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?
Working... howtechoffice 179,980 views 2:30 How to Create a Read Only Form - Duration: 16:13. SC Modules & VBA 0 04-02-2002 02:42 AM All times are GMT -8.
Also if using a custom workgroup file, it must not be the same name as the database (ie.
regards glisando. Microsoft Access Record-locking Information Sign in 8 0 Don't like this video? JimD. 0 Message Author Comment by:WoodstockIT ID: 239324222009-03-19 Peter57r: I guess I am the 00.1% On the File Server, in Windows Explorer, from the highest foilder level to the individual In that case I will procceed to give write privellages to the users.
However, if I assign them to the same group as one of the working users then they can log in as well. https://www.experts-exchange.com/questions/27100287/Access-Could-not-lock-file.html I went to the network folder, I right clicked and selected properties. Could Not Lock File. 3050 Avikash Nadan 155,863 views 5:27 Anyone Can Build a SharePoint Application with Microsoft Access - Duration: 1:17:53. Access Lock File Thanks.
Here you will also see how to give users read only access into your shared database as well as removing this annoying error message that keeps users from even opening your http://gsbook.org/lock-file/ms-access-could-not-lock-file.php Equations, Back Color, Alternate Back Color. On each PC, in Windows Explorer, accessing the mapped network drive, all levels also display Full Control. Could it be something to do with the registry settings of the user's notebook/PC? Open Databases By Using Record-level Locking
Show more Language: English Content location: United States Restricted Mode: Off History Help Loading... I selected the user's name and I found that in the 'Permissions for user' section, I found the tick in the allow box for 'Read & Execute' and 'Read'to be in Edras Rodriguez-Torres 12,921 views 3:05 59. More about the author I've heard this could be a permissions issue so went in and gave all of the users full-control within that folder.
robert_hartlinView Member Profile Mar 4 2008, 09:58 AM Post#3Posts: 18Joined: 25-February 08Thanks for the reply.Even though we have about 100-150 people accessing this form? To be sure your users have suitable Windows/Network rights, get them to create, save and then Delete a Word or Excel file in the folder containing the database files. In my opinion, 'could not lock file' is pointing to a Windows permission issue, not an Access permission problem but if you are getting problems for some Access users, but not
Both original and new users all have the same NTFS permissions to the database and folders on the network. Each should still have their own copy? Tech Support Guy is completely free -- paid for by advertisers and donations. Access Jitsu 2,563 views 6:59 2.27 Creating a Multi User Login System in Access VBA - Duration: 4:40.
I think the problem was in the permissions. Sign in to add this to Watch Later Add to Loading playlists... If the “File in Use” error is received when trying to delete the .ldb file, use the following steps to delete the file Ask the Domain Admin (System Admin) to kill click site Thank you very much.
U… MS Access Windows OS Visual Basic Classic Polish Reports in Access Video by: crystal Polish reports in Access so they look terrific. When changed to allow write priveleges the problem went away. However no matter how I many permissions I give them it still gives the same error on Windows 7 machines. 0 LVL 77 Overall: Level 77 MS Access 67 Message dfriend846, Jun 1, 2007 #5 glisando Joined: Jun 1, 2007 Messages: 15 Hi Guys...