General :: Records Locking - Won't Allow Updates
Nov 8, 2013
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.
View Replies
ADVERTISEMENT
Jul 1, 2015
I want to create a database that keeps track of contributions of members of an association. Every member can voluntarily give a standing order to contribute a fixed amount every month. A member can as well decide to review his/her contribute.
how I can come up with a database that can automatically add the contribution of a member monthly without manual input since the stated contribution is known. So that I can run a report for individual member and the report can capture the every monthly contribution that has been added automatically and shows when ever a member changes his/her contribution amount.
View 1 Replies
View Related
Aug 7, 2012
I have a split database, a front for data entry and of course the back end with all the tables. I have created several Append queries to move records from one table to another (from Applicants to Students, once they are Accepted). The queries work - when I go into the tables and look, there's the data right where I told it to go. But when I open the Students input form (which draws from the destination table), the new data doesn't show up. I double-checked the destination table, and yes, the appended data is all there.
I tried running the simply query that populates the input form, and it doesn't show up in the simple query, either. I've tried Refreshing everything numerous times, tried updating the Linked Table Manager numerous times, opened and closed the program, and no dice - the data is in the table but never shows up in the simple query that populates the data input form. There's no filters on the simple query, so everything in the table should show up - but doesn't.
View 5 Replies
View Related
Sep 11, 2006
Hey all,
I have a problem with my update query (SQL),
The situation where it is used:
The SQL code is as a command on a button on a form. It is used to take the value in the text box(Name: Restock) and update it to the Quantity field in the table. (tblStock)
The problem is that the Update, updates all the records changing all the values in the Column (Quantity) to the value that is in the text box.
I need it to update the record which is displayed in the form not all the records.
Here is the SQL at the minute.
DoCmd.RunSQL ("UPDATE tblStock SET Quantity = (Restock) WHERE ItemID = [ItemID]")
Any help would be great. Thanks in advance
View 4 Replies
View Related
Dec 26, 2005
Hi
I use the Date and Time Picker. i know that i can get many other calendars, however, my theory is that i would rather use something that is directly supported by microsoft. but as i found out now that may not be the case.
on of my users updated his Office 2003 after he was having problems using my database (created on 2002 sp3). i know that the same database works on 2003 sp1. however, now microsoft is serving 2003 sp2. so after the update he he can't use the database.
so my questions:
1. how do i generally prevent users from getting update errors. i would like to atleast alert them with a meaningful message that their version of Office needs to be updated.
2. is this true that the Date and Time Picker doesn't work anymore? and if so, why isn't backwards compatible? and how do i prevent this from happening with other controls or scripts?
thanks,
sam
View 2 Replies
View Related
Nov 12, 2012
I have a Database that has been split into two.
Back-end for all the data.
Front end for all the forms and queries.
The front end has been saved in a accde format and distributed to 20+ users. They have all saved this onto there computers and this is used as an application.The users complete a form on a weekly basis on the application and then save. This then saves into the back end.For some reason I have noticed that a few users submission randomly do not save. For the life of me I cannot understand why.All users have saved them into the back end in the past but every now and then submission for users do not save.
View 5 Replies
View Related
Jul 10, 2012
I have built a database and within it my queries I use for reporting make tables in a separate database. This allows me to work in my data base and update info as needed. My problem is that my make table queries wont run if anyone has one of the report pivot tables open. I have added macros to all the Excel files that pull from the reporting DB but I still have several times when I cannot update because someone is using the pivot table, Is there a way to allow me to update the report DB's while the pivot tables are open? I have tried using manual refresh methods and disabling auto update on open but the result is the same.
View 2 Replies
View Related
Feb 13, 2008
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!
View 2 Replies
View Related
Aug 11, 2005
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?
View 2 Replies
View Related
Sep 30, 2006
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
View 14 Replies
View Related
Jan 13, 2005
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 Related
May 12, 2005
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
View 7 Replies
View Related
Feb 9, 2006
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:
View 4 Replies
View Related
Jan 18, 2005
About 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 Related
Mar 5, 2008
Hey 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
View 5 Replies
View Related
Apr 21, 2005
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.
View 3 Replies
View Related
Aug 30, 2005
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 :)
View 1 Replies
View Related
Aug 21, 2014
I have inherited a number of 2007 Access databases that have a PDF (Adobe Acrobat Document) as the file type for the locking record.
These databases seem significantly slower, and have more frequent "Not Responding" periods on the network - especially when compared to those with a standard ldb file type locking record.
What determines the file type for a locking record?
Can the Adobe locking record be changed to a ldb? and How?
View 9 Replies
View Related
Oct 20, 2014
My database has been set with the 'All records' locking option set to prevent two or more people editing files at once. This is working fine but I wondered if there is a way to make a more personal message appear instead of the default Access one, just to maintain a uniform look.
View 3 Replies
View Related
Aug 12, 2015
I need to lock down my DB so that the users cannot open the navigation pane. The DB opens with an AutoExec that puts them on a Swithboard form.
View 3 Replies
View Related
Nov 19, 2007
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 Related
Aug 20, 2013
On 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]....
View 4 Replies
View Related
Mar 18, 2014
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.
View 2 Replies
View Related
Nov 21, 2012
What is "row level locking"?
How can I get around the "encrypting with a block cipher is incompatible with row level locking" error.
I've never had this error before and I do not know what I did to cause it.
View 5 Replies
View Related
Oct 7, 2005
Hi all
This is an ongoing problem I have had for 4 weeks now.
I have made a a system thats acts like a clock In/clock out Out system.
the structure is somthing like this
ID
Username
tblDailyLog
TimeIn
MorningBreakOut
MorningBreakOut
LunchOut
LunchIn
AfternoonOut
AfternoonIn
TimeOut
All fields apart from ID (autonumber) and username (String*255) are Date field (there are a few others like DateOfTimesheet etc but they arnt important here)
When a user arrives in the morning they make a record which they use for the day
They then have a form with a whole bunch of buttons which simply updates the correct field. For example they click the "Sign in for the Day" button and it updates the correct field with the current time.
Everything was going fine until people noticed that every now and again a sign in time dissapeared.
I have hacked myself to death trying to solve this problem but still the updates go Astray.
Now each time a time is updated the process goes somthing like this
1. the user opens their timesheet for the day (the RS is SNAPSHOT and no locks)
2. User Hits a sign in/out button
3. The record source is changed to "" and all buttons hidden (to ensure the record isnt locked and to make sure you dont do two things at once)
3. The table is updated with the new time (using some dynamic SQL)
4. The table is repeatadly checked using a DO loop to make sure the the correct time went in.
5. when the returned time value of the field matches the varaible used to update it, the form is returned to normal and the user carries on his/her merry way (if it never matches the screen should crash but this never happens).
6. A New record is added to another table called "tblbugfixinglog" which records which field was updated and when. This is so that I have two records in two different ways (figured if one went astray I could pull it back off the other)
7. Another new record is added to yet another table called tblSQLRecord, which simply logs all .RUNSQL statements that are executed.
I thought that the two extra tables (and the check that the record had been updated) would help me track down where the records are going missing, but this isnt the case.
Now it appears that some records arnt being added to tblBugFixingLog and to tblSQLRecord either and some of these tables are getting quite a few #ERROR's in them..
None of the tables are related to any other and i've no idea how #ERROR lines are appearing in a table that has 1 function... to recieve new records ... no editing, no viewing, no deleting.
Does anyone have any idea how these updates/inserts can go missing or create #ERRORs.
I've built plenty of Databases in my time and have never come across this.
__________________________________________________ ______________
This is the function I use to add a record to tblBugfixingLog and tblSQLRecord
Private Sub AddBugLog(ByVal TimesheetNumber As Long, ByVal FieldUpdating As String, ByVal NewFieldValue)
Dim TempSQL As String
TempSQL = "INSERT INTO tblBugFixingLog (TimeAndDateOfEntrySERVER,TimeAndDateOfEntryPC,Fie ldUpdated,NewEntry,UserID,TimesheetNumber,Computer AssetNo) VALUES (" & _
"#" & Format(ServerGetTime(Environ$("LOGONSERVER"))) & "#," & _
"#" & Now & "#," & _
"'" & FieldUpdating & "'," & _
"'" & NewFieldValue & "'," & _
"'" & GetNTUser & "'," & _
"'" & TimesheetNumber & "'," & _
"'" & fOSMachineName & "')"
' MsgBox TempSQL
DoCmd.RunSQL "INSERT INTO tblSQLRecord (Username,DateAndTime,Screen,TheSQL) VALUES('" & LoginInfo.sUsername & "','" & CStr(Now) & "','Add Bug Log function','" & CleanData(TempSQL) & "')", False
'CleanData is a function that removes ' and " from the SQL string so i can easily add the SQL string into the table
DoCmd.RunSQL TempSQL, False
End Sub
Public Function CleanData(ByVal DataToClean As String)
Dim TempData As String
Dim i As Integer
TempData = ""
For i = 1 To Len(DataToClean)
Select Case Mid(DataToClean, i, 1)
Case "'"
TempData = TempData & "`"
Case """"
TempData = TempData & "`"
Case Else
TempData = TempData & Mid(DataToClean, i, 1)
End Select
Next i
CleanData = TempData
End Function
__________________________________________________ ____
I have no idea how this can create #ERROR lines in the table when it is just added to and nothing else.
Does anyone have any clue to what may be happening here.
(Oh yeah and no matter how hard I try, I can't replicate the problem.... works for me every time no matter how harse I am to it!)
Please save what little hair I have left and give me some hope
Cheers
Homer
View 1 Replies
View Related
Jan 17, 2005
Sorry for my English, but i try to description my problem.
I have one form and i want all fields to have the privelage for update
without only the field of s/n ( Key of table ) ???
Any ideas!!! ( I am noob in access and VB )
Help me plz.
Thanks
View 2 Replies
View Related
