I have 4 users entering data via aform. The database is located on a shared drive. They are getting errorsthat the record is locked. I believe this happens when 2 or more people open the form and are trying to enter data at the same time. Is there a way to have each person lock a new record on open at the form? or is there a better way to handle this? I'm new at this and am working my way through.
Thanks
John:confused:
I can't seem to find any answers to this maybe i am asking the wrong question, or its so easy nobody asked.
I am viewing / editing some records in a form, I want to view all of the records but only allow edits to records with forms with tblData.Locked = false.
How do I achieve this.
thanks
Steve
I have and order entry/lookup form with a subform to view the line items on the order.
Once an order has been saved and status is ‘placed’ I want the records for that order to be locked.
I would also like to display a message box with a yes/no answer to confirm that they want to issue the order and if they confirm then lock the record otherwise return them to the open order.
I can't find out how to do this, but I'm sure it can be done.
Any help will be gratefully accepted.
Is there any way to "lock down" newly created records somehow, so that only the person who created them can edit them after the fact?
Obviously, this would require some kind of system where everyone logged in with some kind of userID and password...and even then, I don't know how such a security system could be set up.
Is this possible? If SO, are there any examples of it anywhere that I could check out?
Thanks in advance!
I update the table through a form.
Each page in the form updates one complete row of the table.
I am trying to find a method to block each row of the table (or equivalenty each record in the form) after completing the entry in order to prevent unwanted deletion or alteration of the entries of this record in the future.
Is this possible?
I’m new to access but I have created a table with a form linked to it. It shows one record per page. I just want to be able to lock and unlock individual records in the form by using a checkbox. This will prevent me from accidently making a change to an old record.
For example, when the checkbox is unchecked. the current record on the form can still be edited. When the checkbox is checked, the record can only be viewed, not edited. I still need to be able to navigate through the locked record and create a duplicate from the locked record though. Does anyone know a simple way to do this? My guess that it has to do with the AfterUpdate event? Thanks for any help.
Dale
anyone know about this? i've messed with it, but i think i screwed it up. when one user is using a record and another tries to access it, my program shuts down completely.
View 1 Replies View RelatedAbout six months ago I created a database for tracking customer calls and comments. I replicated this database because I wanted to be able to make design changes without effecting the users ability to add records. I have no security set up for the database except for startup options. I am having an issue with users being locked from adding records once in awhile. The dialog box says "Could not update; currently locked by user 'Admin' on machine '***'". The more I read this the more I am thinking that they are getting assigned the same record ID when they go to make an entry. Although, if the users are patient and wait a few minutes they are able to finish adding the record without deleting it and starting over. There are now 22 people utilizing the database and about 17 of them are using it consistently. Any insight on this would be appreciated.
View 1 Replies View RelatedHey peeps,
Hoping you can help me out with a problem I have... Basically every now and again I get a call from my client saying they cant add a new record, to any table, they get a message saying they are not allowed. I go in and it seems the DB has somehow locked itself and I have to open it up and repair it... it is a multi user setup with the database on a server.... I have seen the users actually end task on Word if it doesnt respond quick enough and was wondering if this would cause the locking problem!? I am just asking to see if there is a setting or something I can do to try and prevent this happening!?
Any help at all much appreciated!!
Thanks
Matt
Hi,
I am working on a test equipment database project. Please could you help with a problem I am having.
I want to be able to lock out records on 1 form based on whether 1 field of its data is found in another table
Any ideas and suggestions would be welcome
Thanks :)
Using 2010 32 bit on win 7.I've been having an issue recently with forms not allowing changes to existing records or adding new records. These have previously worked for years and I haven't done any design changes in 12 months.
Some forms are base on queries that are based on single linked tables and some on joined queries but all have unique identifiers with enforced integrity.I noticed that changing the Record Source in the form from 'Dynaset' to 'Dynaset (Inconsistent Updates)' resolves the issue. But I'm stumped to what's causing this to happen in the first place.
Is it possible to access specific records from a Microsoft Access table without locking the whole table?. I have different processess accessing at the same time different records from the same table and I getting an execption, indicating the table is locked. Can any one provide me some help regarding how to access specifi records without locking the whole table in MS Access?
View 1 Replies View RelatedOn my form I have a set of fields that can be displayed as editable or read-only depending on a "Lockout" checkbox for that record.Is there an easier way of doing this? If not, would it be smarter to create a function to do this? As it stands I'm assuming I would have to have this code run when the form loads, when the Lockout box is clicked, and whenever the record is changed just to ensure that the records are displayed as locked or unlocked appropriately.
Here's what I have:
Code:
Private Sub Lockout_Click()
If [Lockout] = True Then
Me![Customer_Text].Enabled = False
Me![ReqDesc_Text].Enabled = False
Me![MoreInfo_Text].Enabled = False
[code]....
Is there any way other than through coding/controls I can lock specific records in a table.
I have a reference table with less than 200 records on it. 5 and only 5 records need to be locked so that they primarily can not be deleted but also so they can't be edited.
I've read about locking it at form level but that, to me, means some sort of coding.
Hi All,
I am really new to all of this and used to use excel for this stuff.... yes I know... I can hear the screems already .......... :):eek::rolleyes:
What I am trying to do is lock some fields in a form when they are entered so the data can not be changed after they move onto the next record. I think this might be done in the table but can not be sure.
Can anyone point me in the right direction? or some pointers please. Any help would be good.
Many thanks
I am developing a simple database in Access 97, where users have to enter values manually into a form. There is one field called product. Depending on that entry, either field language or country would have to be blocked to avoid invalid entries.
Do you have any ideas on how to approach that problem?
Hi,
I am opening a form, from another form, that is based on a table of 20000 records.
I am using the WHERE criteria to do this, code is included below. I need to provide database access to several users on a network (and only want to lock the record that the user has searched for), and was wondering if this mode of data access will lload and or lock all 20 000 records on the users sytem, or if it will just load and lock the specific record that has been opened using the WHERE condition to open the form...
Advice appreciated.
Regards
Mack
--------
CODE
--------
stDocName = "frmCONTACT"
stLinkCriteria = "[contactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria
End Sub
Hi
I want to set the On Click Event of a button to unlock the current control a user is on. I know the code to set the property of a named control, but I don't want a button for every control I want to unlock. Is there a 'Me' option for controls?
Regards
David:)
I have 4 questions (4 fields) in a form. 2 are drop down menu type and 2 are open text fields.I would like to limit the user from entering data in the fields if one has been answered. for example: if Question one is answered, question 2, 3 and 4 should be locked and should not allow the users to fill in anything. How do I create that Locking system?
View 10 Replies View RelatedHow can i apply the following code to the immediate record in my subform. I would like when the assigned check box value = true, then the fields for that record become locked.
Ive written the following code to an onclick event for a check box labeled "assigned" on my form, the problem is it executes on all the records in my form.
Q. How do i apply the code to only the immediate record?
Private Sub Assigned_Click()
If Me.Assigned.Value = True Then
Me.Serial_Number.Enabled = False
Me.Component_Group_ID.Enabled = False
Me.TypeID.Enabled = False
Me.Description.Enabled = False
Me.Status.Enabled = False
Else
Me.Serial_Number.Enabled = True
Me.Component_Group_ID.Enabled = True
Me.TypeID.Enabled = True
Me.Description.Enabled = True
Me.Status.Enabled = True
End If
End Sub
I'm using Access 2003.I'm trying to create a command for a form that will allow editing or lock all fields, so that records are protected from accidental edits.AllowEdits in the form is set to False by default.I've used the below code to allow a user to unlock the form:
Private Sub cmdEditRecord_Click()
If Me.AllowEdits = False Then
Me.AllowEdits = True
Else
Me.AllowEdits = True
End If
End Sub
And this works without issue.However, I want to create a second button to lock the form again.
Private Sub cmdLockRecord_Click()
If Me.AllowEdits = True Then
Me.AllowEdits = False
Else
Me.AllowEdits = False
End If
End Sub
Seems logical that I should just be able to reverse the true/false but this does nothing!I've also tried the below code:
Private Sub cmdEditRecord_Click()
Me.AllowEdits = Not (Me.AllowEdits)
End Sub
To toggle between editing/locked, with the same results - ie, can switch to editing, but can't then turn it off.
What's the best way to lock down form controls after the user has entered data into them? I will have a button that reads "Save Record" that will make it so the records cannot be accidentally (or intentionally) changed after the button is clicked.
View 1 Replies View RelatedSo I am creating a Complaint Tracking Database with Access 2013. In my 'complaint entry form' I have added to ability to "Open" and "Close" the complaint. While the complaint is open the user is able to enter/edit data in the complaint (new or old). When the complaint is "Closed" (done so with a button on the form that prompts the user to enter a date of their choice) the user should not be able to enter/edit data in the given complaint. In my original thinking, I placed checks on various events (on load, after update, on click) that checked to see if the current complaint had a date in the "Close date" field.
If the close date field was null then that meant that the complaint was open and the the controls would NOT be locked. If the close date field was NOT null (i.e. a date was present) then the complaint was closed and the main form fields were locked but the data was still viewable and unless they "re-opened" the complaint they could not change the data.
Now, in the complaint entry form, I have a subform that acts as a action tracker that is used by the user to keep track of the actions taken on the complaint (i.e. they requested documentation from such and such on this date..etc). My problem through all of this is upon closing the complaint and locking the main form controls, my subforms data just vanishes! At first I figured the problem might be with the linking of master and child fields, so I made sure that I left the ID in the main form unlocked when I loop through my controls during the locking process. This did not solve my problem. Code below:
Private Sub Form_Load()
Dim ctl As Control
If Not IsNull(Me.close_date) Then
Me.FormHeader.Visible = True
Me.btnClosed.Enabled = False
Me.btnOpen.Enabled = True
For Each ctl In Me.Controls
[Code] .....
I have a company wanting to asses my database and i am willing to show them but i need to be able to lock the database so that they can view it but cannot edit anything in it either adding deleting or plan editing. How can i do this.
Bullfrog
The Amateur
Hi, I just recently split my Access db (FE/BE), copied the FE to each of the clients, and it seemed to be working fine. This morning however, two users went into the db, and the second user kept getting the error can't find the file \servernameshare_namedb_fe.mdb. Now, none of my users can launch it. How can I resolve this? Will this keep happening?
AP
I have to send an access application out to some people who need to preview it's functionality. What is the best way for me to send this .mdb file to them so they can use it (tables, forms, queries, macros and functions) but still keep them from opeing up the objects and viewing the code behind them? Is there a way of sending the .mdb file out so that objects cannot be seen in design mode and the objects cannot be viewed other than through the flow of the application? As you might have already guessed, I am new at securing an .mdb file for outside use. Your help would be greatly appreciated.
Thanks!