amidyne Posted July 31, 2008 Share Posted July 31, 2008 On my database at work I have set up several different account privileges to allow/disallow access to different layouts. What my boss asked me to modify today was the number of users on a layout at any given time. He was concerned that data may get modified at the same time by 2 different people. I was wondering if there was a way to lock out other users from the layout when it is being modified. Any and all help would be greatly appreciated Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted July 31, 2008 Share Posted July 31, 2008 FileMaker Pro handles this for you automatically. Only one user can be editing a given record any given time. If another user attempts to edit that record, the second user will get an error message. This process is known as record locking. Steven Link to comment Share on other sites More sharing options...
amidyne Posted July 31, 2008 Author Share Posted July 31, 2008 Thanks Steven, I hadn't considered this. As it turns out it was actually me who was causing the issues. I was updating the look of the layout and making it run better while people are on it, and it turns out sometimes they were having issues with what I was changing. Lesson Learned: Be more careful in the future Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted July 31, 2008 Share Posted July 31, 2008 I would counsel against making schema changes on hosted files generally, but especially when there are guests connected to the database. Steven Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5746 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now