Lock File Fills Up
Jun 18, 2007
Hi,
We have manufacturing/shopping software that has an access backend. There is about 15 users access it via terminal services.
From what i know, access only allows for 256 connections, and that number can be viewed with the LDB Viewer.
The problem is that if someone doesn't log out, the database doesn't reset itself. The next day, the lock file will still be a high number, and the shopping software will have errors running reports.
I dont understand how this happens. If there only 15 users, how cant there be so many connections? What makes the count build up? What can i do besides kick everyone out to reset it?
thanks
View Replies
ADVERTISEMENT
Nov 1, 2004
I created a database for one company. So, this database needs to support multiple users environment. One of the users has problem opening the database. Sometime he can open it. …. sometime he has an error message “Could not lock file”. What’s wrong with the database? (I gave him permission to “Read”, “Write” and “Read & Execute”)
Thanks in advance for all your answers.
View 1 Replies
View Related
Nov 30, 2005
Hi all,
We are changing domains and are doing alot of bouncing around with passwords and such.
Now all my users who are not in admins can not open our Db.
We get a message 'Could not lock file'. Any ideas?
thanks
View 3 Replies
View Related
Sep 26, 2006
Hi folks - need some help with what is probably very easy but I just can't get it.
I am running an access database on a 2 pc network with shared access etc. I can see all files on both computers but when I try to open the same file on both systems I get error message " could not lock file" I had another database earlier this year working on the two machines perfectly and was able to input data from both and the file was not a froint end back end structiure.
also if is any help the second machine only seems to be able to open in Read only mode. I have tried the user permission on the my computer allow shared access but this has not fixed it.
Any ideas much appreciated
Thanks
Humph
View 2 Replies
View Related
Feb 26, 2006
Hi there, we currently have a database that users write to through an excel form. Each time a user sumbits a record to the database we open a connection up with the below code, insert the record and then close it. This creates a ldb file for 1-3 seconds depending on how long it takes.
' OPEN DATABASE CONNECTION
Set dbConn = New ADODB.Connection
dbConn.CursorLocation = adUseClient
dbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0"
dbConn.Open sConn
' INSERT RECORD THROUGH EXECUTE COMMAND
dbConn.Execute("INSERT INTO.... VALUES....")
' CLOSE CONNECTION
dbConn.Close
Is it possible to open the connection up without an ldb file being created so more than 1 user can insert a record into the database at the same time?
Thanks for your time,
Cheers
Tony
View 6 Replies
View Related
Dec 19, 2006
In the lock file I noticed I can see the computer names of the people who have the db open. Is there a way to get the login names from this file so I can knock some sense in my co-workers who still have the database on
View 1 Replies
View Related
Jul 27, 2005
Hi,
I have some code which updates an invoice table with transaction numbers. It worked ok until this month when we had to run three months worth of invoices in one go. I recieved a runtime error 3052 "File Sharing Lock Count Exceeded" and Access told me to increase the MaxLocksPerFile registry entry. I thought i'd better check it out a bit first though and found the following on support.microsoft.com
In Microsoft Access 2000, you can take advantage of a feature that allows you to increase the MaxLocksPerFile setting for Microsoft Jet database engine 4.0 by editing the Windows Registry. The default value of this setting is 9500. However, changing this value is not recommended if one of the replicas is located on a Novell Netware server, because the server's maximum record locks per connection is 10000.
The invoice table had about 20k lines but as I am on a netware server i'm not gonna be able to squeeze more than 10k lines out of my recordset so I was wondering if there is any way I can open it without record locking? The table that is being modified is never edited apart from in this one process so there is no risk of complications there.
Here is how I opened the recordset
Set rstInvs = dbs.OpenRecordset("SELECT [InvNumber], [InvNumExt], [TransactionType], [LineNum] FROM [tblInvoices]" _
& "WHERE [LineNum] Is Null ORDER BY [InvNumber], [InvNumExt], [TransactionType]")
Any help would be much appreciated.
thanks, Tom
View 14 Replies
View Related
Sep 29, 2012
Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.
When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?
View 2 Replies
View Related
Apr 7, 2015
What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This would allow the end users to zip this file up and send it to me.
Because of all sorts of stupidity, I have no network capability and must send data back and forth via email.
I have digressed to a replication table that needs to be uploaded, once data is entered by the users...
Because the files can get relatively large (for emailing purposes), I am trying to figure out how I can get just one table from them vs. sending the whole application file back to me... It's pretty vital that they not be able to edit the table because that could really mess up the process.
So any way to create a new lock file from within the current Db?
View 1 Replies
View Related
Jul 2, 2013
We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.
View 12 Replies
View Related
Jan 11, 2005
I have 2 tables and I am trying to link them using a 3rd table, as per a previous discussion, this is a new enquiry.
I have two fields on the new table that I want to display the same information as the first table. Ie. Co ID and Co Name.
Is there a way to when selecting the Co Name auto fill in the Co ID?
This would also be usefull in my call record form, where I select a name and the Phone numbers auto fill in.
I can put several fields in the lookup combo box, but I cant get the info from them to the other field.
Thanks :)
View 2 Replies
View Related
Jun 13, 2014
Some background: I have a subform that is displayed in datasheet view, with an unbound textbox (field1) whose sole purpose is to pass the date and time entered into it to field2 (hidden, bound), and also display that info in this format: ddhhnn"Z" mm yy. The inputmask for field1 is 000000"Z ">LLL�0 which forces the user to enter the date/time using the ddhhnn"Z" mm yy format. I use field1's AfterUpdate event to convert its contents into a format (dd/MMM/yy hh:mm) that field2 can easily recognize as a date and time.
My problem: The only way I've figured out to get field1 to display field2's date and time is to use the subform's OnCurrent event:
Code:
Me.field1 = Format([Field2], "ddhhnn""Z ""mmm yy")
However, by doing that, whenever I click on a record's row the entire field1 column populates with the current record's field1 value. So, if I click on record 2's row, the entire field1 column populates with "101200Z JUN14" for every record. If I click on record 3's row, the entire field1 column populates with "111232Z JUN14" for every record. And so on and so forth.
How can I stop field1 from populating with the same value for every record?
View 3 Replies
View Related
Jun 13, 2005
I need to lock and unlock a a few text fields with a CMd Button.
and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.
can some one throw me a clue?
View 2 Replies
View Related
Aug 23, 2006
My company has a network with an Access application front end and an Oracle back end. The back end is read only. The folder in which the Access application resides is shared with other departments who have been concerned about people who use our application having any contact with their applications, whatever they may be. Everyone who used the Access application has had Full Control rights on the old folder.
Our application was moved to another folder which is in another folder to which no one has access. To get to it, the complete path must be typed in; the browser can't be used because the forbidden folder can't be opened.
Only a few users need Write access to the application. Everyone else has been given Read Only access to the folder in which the application resides.
We are now finding that when the second person tries to access the application in its new location (it was deleted from the old location), they get the "Could Not Lock File" error message and the applicattion won't open. The Access application has no security on it at all-everyone has full rights to do anything they want in it. At corporate's insistance, the only controls on who can do what are the permissions that are associated with the folder.
We are having a few of them apply for Read Write access to the folder to see if this solves the problem but it will be a few days before anyone gets the permissions changed.
In the meantime, does anyone have any idea if this is the problme or could it be something else? By the way, this only started happening in the last day or two but people have been requesting permission to the new location for about a month.
View 2 Replies
View Related
Apr 27, 2005
I currently have two forms: frmE_SAFind and frmE_SAOrder
frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate]
Example:
IDPO Date
btnOpnFrm 6543 2/1/05
btnOpnFrm 5681 1/1/05
frmE_SAOrder shows order details including [txtIDPO] and [dtmDate]
I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command?
Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details.
Hopefully I made myself clear enough to understand. Thanks for your help!
View 1 Replies
View Related
Aug 15, 2013
I have a form with two textboxes called: txtAptDep, txtAptArr.
On their right side there are two buttons (btn1, btn2) to open a form called frmAirportSearch. It allows to choose (from a listbox) the airport to be filled in those two textboxes.
Now, if I search for an airport pressing btn1, I want the airport to be returned into txtAptDep, while if I open the form by btn2, the airport choosen must be returned in the second textbox.
View 7 Replies
View Related
Apr 22, 2006
Hi,
I create the datasheet form,
I know how to lock the field, but it lock the whole column of the field.
I want to lock the field except the last record field only.
Can I do that?
eg.
ID Field1 Field2
1___a______b
2___c______d
3___z
I want to lock the field2 except the ID=3
Please let me know, thanks.
View 1 Replies
View Related
Oct 30, 2005
My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way.
tables
tblPolls
tblIssues
Querries
qryPolls
qryIssues
qryFindPollsByID
qryFindPollsbyName
Forms
FrmFindPolls
FrmSearchResultsbyId
FrmSearchResultsbyName
FrmIssueTrackingMain
FrmIssueTrackingSub
The Form Issue Tracking Main has the Sub form IssueTracking Sub
Here users enter the issues in the sub form. The forms are linked by Poll ID
Is there a way to lock all the records with the same pollid in the tbltblIssues. Also to check who is editing them at the time?
View 2 Replies
View Related
Apr 5, 2006
I've set up a database for use by a team of approx 10 people. I've got problems with locking records so that only 1 user can edit a record at one time. This is happening in a form with a subform included... Can anyone help?
View 6 Replies
View Related
Aug 16, 2007
hello,
Access gives me the following error:
runtime error 3326 this recordset is not updatable
How do I make a recordset UPDATABLE?
2 days ago, I was able (from front end file) to open a table (in the back end in another computer) and modify the records or add a new one. Yesterday, Office 2007 was automatically updated from the internet, and now I can open the tables but it locks me (it doesn't let me modify or add anything)
Does anyone have any idea of what's going on and how to fix this?
thank you
View 6 Replies
View Related
Oct 13, 2004
hi,
i have created a table with 2 records.i want to lock the record such that nothing can be done with the existing records but allows to add new records.wat should i do??
thank u
View 3 Replies
View Related
Nov 5, 2005
I want to lock a table to disallow further records.
I want to have only one record (I would have created this rec by myself) to store initial conditions and infos such Username/company etc.
Any ideas?
I'm also interesting in other solutions than locking a table if sucj a thing is not possible or nt functional.
Tnx in advance
View 3 Replies
View Related
Dec 1, 2005
I have a created a database for insurance policies.
I'm using a form in the database to edit the data in the underlying table.
I use "pessimistic lock" in the database and in the form.
The database runs in a multi-user environment.
My question is the folowing:
When a user is editing a record, it is obvious that this record is set to
lock in the table (--> pessimistic lock), but the 4 records that are right before this record
are also locked too!
There is nobody else editing at that same moment in the database and it is
not a one-time occurence!
Can somebody help me out with this one... I'm realy desperite and I
searched the entire forum.
View 2 Replies
View Related
Apr 12, 2007
I'm working on a database that calls on a table of zipcodes. All of these zipcodes have latitudes and longitudes connected to them..... I've searched around but cant seem to find anything on locking a table. Is it possible to lock down a table so changes cannot be made?.....(until I need to make them)
View 1 Replies
View Related
Aug 30, 2007
hello to all
i want to lock the tables and queries of my database in access so the users cant modify any information
View 1 Replies
View Related
Feb 2, 2005
Hi all. I have a form that when I click a button is automatically changes a field on another form and then closes both forms. Can I add anything to this button to stop that record from being altered again. IE. when i click on this close job button nobody can ever change the record again. Thanks.
View 1 Replies
View Related
