HELP
in [General]
|
From: Daniel Kaseman on 13 Feb 2006 10:42 Will someone (an expert) please help me figure out how to prevent the following error from occuring: "Couldn't Update; Currently Locked" This error displays when i click on the plus sign on the table record, to display the Subdatasheet. I noticed that if there are several users entering data into the table that the subdatasheet is linked to, that the error occurs then. I proved it. I asked 2 of the users of our 5 user team to exit out of that particular table, and then I went back to my computer to click on the plus sign, and the subdatasheet appeared normally, no error message. All 5 of us are entering data into the same table that has the same subdatasheets, and each one of us may occasionally get the error if more than one person is entering data into THAT table. But isn't MS Access supposed to allow more than one user to enter data into the same table at the same time? I thought the above error should only occur when 1 user is modifying the data of 1 field in1 record, while at the same time another user is modifying the same data of the same field of the same record. But this activity is NOT what we are doing. We are all entering data into different records, but in the same table. Thank you for your assistance, Daniel
From: Tom Coffinger on 13 Feb 2006 10:51 Daniel, The best answer is .. Never, ever, ever enter data directly into a table. Tables are like the 2by4's inside the wall of your house. You have to have them, they hold everything up, but you should never see them. Instead, you manipulate data with forms based on tables/queries and withVBA. "Daniel Kaseman" <danielkaseman(a)hotmail.com> wrote in message news:%23qp$TQLMGHA.2668(a)tk2msftngp13.phx.gbl... > Will someone (an expert) please help me figure out how to prevent the > following error from occuring: > > "Couldn't Update; Currently Locked" > > This error displays when i click on the plus sign on the table record, to > display the Subdatasheet. > > I noticed that if there are several users entering data into the table > that > the subdatasheet is linked to, that the error occurs then. > > I proved it. I asked 2 of the users of our 5 user team to exit out of > that > particular table, and then I went back to my computer to click on the plus > sign, and the subdatasheet appeared normally, no error message. > > All 5 of us are entering data into the same table that has the same > subdatasheets, and each one of us may occasionally get the error if more > than one person is entering data into THAT table. > > But isn't MS Access supposed to allow more than one user to enter data > into > the same table at the same time? > > I thought the above error should only occur when 1 user is modifying the > data of 1 field in1 record, while at the same time another user is > modifying > the same data of the same field of the same record. > > But this activity is NOT what we are doing. We are all entering data into > different records, but in the same table. > > Thank you for your assistance, > Daniel > > > >
From: Joseph Meehan on 13 Feb 2006 13:47 Daniel Kaseman wrote: ... > > But isn't MS Access supposed to allow more than one user to enter > data into the same table at the same time? > Yes, but the recommended method is to use a split database system where each user has their own copy of the front end on their computer and all editing of data is accomplished via forms. From your message I can't tell if your database is split or if you are trying to edit data directly in the table. -- Joseph Meehan Dia duit
|
Pages: 1 Prev: Adobe PDF hyperlink Next: I am trying to convert an access table into a fixed length text fi |