|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Back-endIs it possible to open the same table through a couple of different forms.
I have networked my database and left the bank-end on the network drive and the other users each have a copy of the front end. Can they still all use the same form simultaneously even if it runs off the same table as at present, i keep gettign the message "locked out". Many Thanks, Matt p.s. Sorry Joan, am very rushed on this matter There should be no problem with multiple users all trying to read the same
table simultaneously. However, if they try to update the same page of the table simultaneously, then you will get a "locked" message. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message news:9863FA10-9EB6-45B5-A878-2D7FA8BE0504@microsoft.com... > Is it possible to open the same table through a couple of different forms. > > I have networked my database and left the bank-end on the network drive > and > the other users each have a copy of the front end. > > Can they still all use the same form simultaneously even if it runs off > the > same table as at present, i keep gettign the message "locked out". > > Many Thanks, > Matt > p.s. Sorry Joan, am very rushed on this matter How do you mean by the "same page"
At the moment no more than one user can access the table at one time let alone open the form to edit the details Matt Show quoteHide quote "Douglas J. Steele" wrote: > There should be no problem with multiple users all trying to read the same > table simultaneously. However, if they try to update the same page of the > table simultaneously, then you will get a "locked" message. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message > news:9863FA10-9EB6-45B5-A878-2D7FA8BE0504@microsoft.com... > > Is it possible to open the same table through a couple of different forms. > > > > I have networked my database and left the bank-end on the network drive > > and > > the other users each have a copy of the front end. > > > > Can they still all use the same form simultaneously even if it runs off > > the > > same table as at present, i keep gettign the message "locked out". > > > > Many Thanks, > > Matt > > p.s. Sorry Joan, am very rushed on this matter > > > Since multiple users are actually accessing the data through their own
front end, they won't cause each other to get locked out. this is because they are not all in the same front end at the same time accessing the same form. It is advisable to change the Record Locks property on the form to Edited Record so that it locks the record the user in question is on. Then if another user attempts to edit that same record, the locked message will appear. but if any other user is on some other record in that same table, there won't be any issues. Matt Dawson wrote: Show quoteHide quote > How do you mean by the "same page" > > At the moment no more than one user can access the table at one time let > alone open the form to edit the details > > Matt > > "Douglas J. Steele" wrote: > > > There should be no problem with multiple users all trying to read the same > > table simultaneously. However, if they try to update the same page of the > > table simultaneously, then you will get a "locked" message. > > > > -- > > Doug Steele, Microsoft Access MVP > > http://I.Am/DougSteele > > (no private e-mails, please) > > > > > > "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message > > news:9863FA10-9EB6-45B5-A878-2D7FA8BE0504@microsoft.com... > > > Is it possible to open the same table through a couple of different forms. > > > > > > I have networked my database and left the bank-end on the network drive > > > and > > > the other users each have a copy of the front end. > > > > > > Can they still all use the same form simultaneously even if it runs off > > > the > > > same table as at present, i keep gettign the message "locked out". > > > > > > Many Thanks, > > > Matt > > > p.s. Sorry Joan, am very rushed on this matter > > > > > > But they are all running off the same table and it says that as one person
has access to the table then the others are "locked out". If i change the edited record, will this solve the problem? Matt Show quoteHide quote "godiva" wrote: > Since multiple users are actually accessing the data through their own > front end, they won't cause each other to get locked out. this is > because they are not all in the same front end at the same time > accessing the same form. It is advisable to change the Record Locks > property on the form to Edited Record so that it locks the record the > user in question is on. Then if another user attempts to edit that same > record, the locked message will appear. but if any other user is on > some other record in that same table, there won't be any issues. > Matt Dawson wrote: > > How do you mean by the "same page" > > > > At the moment no more than one user can access the table at one time let > > alone open the form to edit the details > > > > Matt > > > > "Douglas J. Steele" wrote: > > > > > There should be no problem with multiple users all trying to read the same > > > table simultaneously. However, if they try to update the same page of the > > > table simultaneously, then you will get a "locked" message. > > > > > > -- > > > Doug Steele, Microsoft Access MVP > > > http://I.Am/DougSteele > > > (no private e-mails, please) > > > > > > > > > "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message > > > news:9863FA10-9EB6-45B5-A878-2D7FA8BE0504@microsoft.com... > > > > Is it possible to open the same table through a couple of different forms. > > > > > > > > I have networked my database and left the bank-end on the network drive > > > > and > > > > the other users each have a copy of the front end. > > > > > > > > Can they still all use the same form simultaneously even if it runs off > > > > the > > > > same table as at present, i keep gettign the message "locked out". > > > > > > > > Many Thanks, > > > > Matt > > > > p.s. Sorry Joan, am very rushed on this matter > > > > > > > > > > > Access stores records in pages. They used to be 2K blocks: I believe they're
4K blocks now. The number of records on a page will depend on the size of each record. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message news:E9E3F457-6F89-4D30-A7EF-7495022DE0A6@microsoft.com... > How do you mean by the "same page" > > At the moment no more than one user can access the table at one time let > alone open the form to edit the details > > Matt > > "Douglas J. Steele" wrote: > >> There should be no problem with multiple users all trying to read the >> same >> table simultaneously. However, if they try to update the same page of the >> table simultaneously, then you will get a "locked" message. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "Matt Dawson" <MattDaw***@discussions.microsoft.com> wrote in message >> news:9863FA10-9EB6-45B5-A878-2D7FA8BE0504@microsoft.com... >> > Is it possible to open the same table through a couple of different >> > forms. >> > >> > I have networked my database and left the bank-end on the network drive >> > and >> > the other users each have a copy of the front end. >> > >> > Can they still all use the same form simultaneously even if it runs off >> > the >> > same table as at present, i keep gettign the message "locked out". >> > >> > Many Thanks, >> > Matt >> > p.s. Sorry Joan, am very rushed on this matter >> >> >> Matt Dawson wrote:
> Can they still all use the same form simultaneously even if it runs off the Go to Tools | Options | Advanced. Make sure the default open mode is "Shared.> same table as at present, i keep gettign the message "locked out". " Set default record locking to "No locks." Make sure the check box for "Open databases using record-level locking" is checked. Compile the code and compact the database. (Making an MDE is a good idea at this point, too.) Have everyone exit out of the application and make sure that the LDB file for the back end is deleted. (If everyone doesn't exit the database your setting for "Open databases using record-level locking" will be ignored, because whatever the setting was for the first person to open the database is applied to all subsequent users until the database closes.) Redistribute this new front end file to all users. Now let the users open the database with the new front end. The users shouldn't be locking each other out of the form any longer, but they can get a warning that someone else is editing the record they want to edit if someone else is already updating it. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200610/1 
Other interesting topics
Where is workgroup manager in access 2007?
restricted user level security How to add the security back to the normal database? Multi users in one form Help with replication problems Planted temp files on my computer? RWOP and database permissions on backend I am Locked out of my access database 2000 need help with permissions |
|||||||||||||||||||||||
