Another User Is Editing This Record
Hi I was wondering if anyone could shed any light on this problem. I have a new database going live in two weeks. My problem is that I keep getting a message telling me that someone else is editing the record.. which is an impossibility as it is a stand-alone copy on my hard-drive at home! How is this possible? Will this problem be solved once I have this database on the sql server and the tables has been upsized to sql? Also this database is to be used by up to 100 people is this going to be a problem?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
How To Lock Records To Prevent User Editing?
Good morning! I'm building a database for use by four technicians in a call-center type operation. The call records are purely transactional in nature -- once the call has been logged, the record is closed. If the customer calls again, a new record is opened. The supervisor doesn't want the techs to be able to go back and edit a record once it's entered -- the records are for quality-control purposes and he doesn't want them gaming the system by going back and changing things after the initial call is logged (let's not discuss the issue of employee psychology, motivation, Office Space, etc.). So I'm trying to figure out how to do that; they all have wheel mice, and I can currently see all the records as I scroll back and forward with my mouse wheel, so I'm assuming they'll be able to, as well. Any help? Thanks, Andreas
View Replies !
View Related
Record Locking. But No Editing
Please help ME!!! I've got a data entry form with Bridge details and a separate form which contains all the construction data for the bridge. All data is stored in SQL server and the front end is in MS access. Since moving the data to SQL when a new construction is added to a bridge the data in the construction table becomes locked and can only be edited from the SQL backend and not from MS access. So the question that I hope you can answer is :- Why does the single row get locked after its been saved and stay locked And how can I stop this from happening?
View Replies !
View Related
Problem When Editing Record Via Form
i have a form to edit customer details, my problem is if i edit a record so that it breaks validation / inputmask, then i get my error messages. is there anyway to prevent these messages from appearing until i click a command button to save the changes? i have on my form a command button to open a .chm file and another button undo changes and exit form but there is no way i can click these buttons because as soon as the field loses focus i get the error messages. thankyou
View Replies !
View Related
Duplicating And Editing A Record Via A Form
Earlier this year I was daft enough to mention at work that I was interested in learning a bit about access databases. As a result of that my boss has set me the task of replacing some old Dbase IV databases with Microsoft Access. I have started with importing data from an old document database and sought a wee bit of parameter query help in this forum a couple of months ago. As a result of the direction I was pointed in I have produced a creditable search facility via forms for my new document database. I have now turned to the data entry via a form and have come to a grinding halt with reproducing a feature the old Dbase one had. Once an entry for a new document was completed a message box would open asking if there was a second copy, with the answer no the entry would be saved and it would move onto the next new record. If the answer was yes it would duplicate the completed entry as a new record and modify the copy number +1 and save the record. This would be repeated for however many copies you had and until you answered. I have added a duplicate record command button to my form which works well but I have no idea how to modify the copy number field to reflect that this entry is for the second, third etc copies. Each document record has a seperate field for the copy number. I would welcome any help you can offer or directions to where I can find the answer. Many thanks
View Replies !
View Related
Help! Having Trouble Editing A Record Using A Form
Dear access experts, I created form based on a query of around 7 tables, all the fields are set to enabled and edits are allowed; however, access wont allow me to edit any of the fields in that form! I know that the query is correct because i can flick through the records and the fileds change.. please help:eek:
View Replies !
View Related
Editing By Combo Selection Not Record?
Hi, I am trying to update prices changes for products in my inventory database, and am stumped. I select a vendor, which then populates the product name from which I can then select the product I want to update. From here, it populates what the current prices are. I then can type the new price into the next box, but what happens is that it doesn't change that Product it changes the 1st record. Can anyone help!
View Replies !
View Related
Multi-User - Can You Assign Which User Created/amended A Record?
Hi guys, I've seen different log in forms and tips on multi-user use but can't seem to find info on the following... We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer... Best ideas anyone? dazza61
View Replies !
View Related
User Record Security
Hi Guys I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the security correct before i go any further. My question is how do i configure it so that users can only update or change or delete thier own entries apart from me who could alter anything. Do i begin now when i am setting up the tables or is it a bit more complex and would require checks during accessing forms etc. Any help and advice would be great Many Thanks Martin
View Replies !
View Related
Another User Did Not Edit This Record!
I have a form based on a query that selects only the people working in a single office, and displays various personnel data items. All of the data is contained in a single table. Whenever I update any of the data in the form, I get a message saying that another user edited and saved the data before I edited the data. Its rother annoying, and I can't figure out why it is happening. The form is bound to the query, and a list box contains the names of the folks. A subform contains the personnel data, and the two are connected by the primary key.
View Replies !
View Related
Update A Record When A Certain User Signs In The Db
The Database is not split. Have 30 some users. Here is what I am trying to do. I have Mary, Sam and Bill logged into the database. When Mary signs in she has no records to update, but when Sam and Bill logs in they have records to update. How can I get a message just to Sam and Bill, but not to Mary? I have a qry what records needs to be updated. Just how would I go about this? I thought I had it when I use the "environ" but that just shows who is logged in. I am sure the form has something, but I haven't found out where. Can you point me in the right direction?
View Replies !
View Related
Message For Record Lock By User X
Is there any way of creating a personalised message if a record is locked by user A and when it is trying to be accessed true a form by user B and that user B in no condition can access this record , not even for reading (form cannot been opened)? The message should be like this: "The record you are current'ly trying to access is locked by Uuser A (= username of the person who is locking the record) and cannot be accessed at this moment. Please try it again later."
View Replies !
View Related
Multi-user Record Contention
I keep thinking this is so obvious I shouldn't have to ask, but.... I have a database, the back end sits on the network. Forms in the front end are bound to the data in the back end. This is certainly not optimal, but it has worked. I'm guessing other uses of the network have increased, though, cause now, Access occasionally chokes when trying to open the forms. So I need to unbind them. Okay, I know how to do that. Trouble is, how do I deal with multiple users accessing the same record at the same time. With bound forms, Access may not handle it as elegantly as possible, but at least it does try to handle it. Every example of unbound forms I have ever seen have grabbed data, used it to populate the form. Then if the record is edited, throw the changed data back to the back end. But what if someone jumped in between when the data was grabbed and when the changes were written back? How do I handle that? To make matters worse, my users absolutely want to be able to continue to search and filter the forms. Plus, the form has detail data in continuous sub-froms. I am thinking of accomodating that by up front having them select a subset of records, either all for a given customer, or hopefully, just a given invoice. I plan to copy that to a table on the front end, and bind the form to that copy. When they change the beginning filter value, I would write the data back. But that could be hours later. Lots of time for the data to become stale. Any suggestions on how to deal with these issues? Pointers to where is has been discussed before? (Hey, I did look, but all I found were vague, "you have to watch out for...." but never a way to handle it when it does happen.) Thanks, David
View Replies !
View Related
User Unable To Save Record?
I have a problem where a user (with what I believe are the proper security settings) cannot save a new record in a form. I have set the securities on the form and the related table and query to allow this user to create new records (Add/Run). This user is able to access the form and enter the data, but it will not save. I have added a "Save" button to no avail. When I log on as the administrator, it works fine. Any Ideas? Thanks in advance.
View Replies !
View Related
Multiple User Receiving Record Locked
Hello, I have a database we use to enter new account numbers and several other atribbutes about the account and it is split into a FE/BE with the BE in a shared folder. I have the open database using record-level locking checked but it seems to me that the database is opening up with page-level locking. Multiple users will receive a message that the current record is locked and I am sure that they are all not updating the same record. Does anybody have any idea's of what I can do? If nothing else I am going to have to recreate my form as an unbound form and see how that goes.
View Replies !
View Related
Current User Default When Adding A Record
If I have a field in a table called "AddedBy", is there a way for this to default to the CurrentUser that's logged in to the database when a record is added to the table? I know you can use "Application.CurrentUser" both in the VB code and within SQL queries, but it doesn't seem to work if I put it in the "Default Value" box with the table editor. Any thoughts on this would be appreciated. Thanks!
View Replies !
View Related
Form Event To Alert Before User Moves Onto Another Record
Hi, I have a form with some bound fields and some unbound fields. If I make any change to the bound fields I can use the "Before update" event to perform some actions when a user tries to move onto a new record. What I now need is if a user doesn't make any change to the bound fields but makes a change to an unbound field - how can I check this before the next record is displayed. Is there any event I can use? Each time a user tries to move to a new record I want to check first if they have added anything to an unbound field. Users can move onto the next record using buttons or the record navigator at the end of the form. Many Thanks,
View Replies !
View Related
Showing User Who Modified Record On Form View
I used a macro to record the date and time the current record was modified and show that information on a form - the information on how I did that is here: http://office.microsoft.com/en-us/a...0345351033.aspx That works wonderfully, however I would like to add to this the user that modified the record. Is there a macro code for this?? I tried setting the Item to read [UserModified] and the Expression to be User() however that did not work. Any help would be greatly appreciated... thanks.
View Replies !
View Related
Record Locking - Multi User Worklist Type Database
All, Bottom line I'm in bit of a pickle, work has moved forward the migration of Office97/NT4 to Office2003/XP by 2 months (clever lot) and was hoping not have to cram for this question until at least 3-5 weeks. I'm looking for pointers/suggestions because I now have to test in Access2003 Runtime on MONDAY!!!! What it is, is: I have a query which is a list of items that need to be worked out of 65,000. Of that 65,000, 20,000 end up in the query (Actually do need looking at after an Automated process) (it's adapting the query/process I think I need) Query: EntID - UniqueID for a household Applicant1 - Number lookup value for Applicant 1 Applicant2 - Number lookup value for Applicant 2 Qualifies - 1 = Yes, 2 = No, Null = Not worked. That's basic building block of the Query which is Drives the main Form. What I would like is a scenario similar to this: Person A opens record 1 Person B opens record 2 Person C opens record 3 Person C finishes record 3 Person B finishes record 2 Person C opens record 4 Person B opens record 5 (he/she took a little break) Now that's the way I would like it to work, but there will be other factors and this is where I'm all ears for anyone who is used to this type of system. The problem I can't figure out is that the Main Form has several subforms, but none of the data is to be edited, it is there for visual purposes only. The users will be creating records via the Main Form through code, but not directly into any tables/queries with which I can use conventional record locking, that I can see. My thoughts are that Person A calls up a record based on Min EntID and somehow locks it so the Person B looks for Min EntID Where not locked. -------------------------------------------------- Question Time: Please, please can someone point me in the direction of how to do it and more importantly the correct order of events? I have tried doing the Min EntID and locking the record, but while Person A is running the Min Query, Person B is running it also so they end up with the same record as B has the record on screen while A is locking it. Also, In the real world Person B might open record 2 and think, nah I can't be bothered. I would like a proffessional opnion on whether C opens record 2 or should B be made to deal with it. I think not given the huge time constrants landed square on my lap, I would get there with smaller questions, but I've spent the last 10hrs writing a Function, to get it ready for the testing lab, where the owner has changed the requirements 7 times and my head isn't working. All or some help given will be GREATLY received. Any further information needed, just ask. Hope you can help. Cheers, Ian Mac
View Replies !
View Related
Need Ideas: Alert User When Record Hasnt Been Updated In Over An Hour
I have a form in continuous forms mode... Each entry is something the user is supposed to check on once and hour and update. I have a "Last updated" field. Now() goes into that field every time the record is updated. I have a querry that will show the users records that are over an hour old. How can I get Access to pop-up a window or something to alert the user they need to look at something? It would be really nice if Aspect would start blinking in the task bar or something. Thanks!
View Replies !
View Related
|
TRACKER
