Hi I have a problem with my access table - I am seeing the following error even though I am using this in a single user environment, don't have the dreaded .ldb file present and do not have anything else open!
'A query or form bound to the table is open, you do not have permission to open this table in design view, or another user has this table open'
Help! :eek:
I have a table which is linked to a form which has been working fine for over a year now but yesterday the table "locked" for editing. I can now only copy data from the table. The editing functions delete, cut, new etc are not working, we can still filter the data.If we enter data on the form it creates a new line on the table but we cannot edit directly from the table.
View 6 Replies View Related:eek: :eek: :eek: :eek: :eek: :confused: :confused: :confused:
I am trying to update a database table via a command button on the main form, that uses tabbed sub forms.
The database gets its data from paradox data tables copied our company's
third-party software. These table files are copied from one location to another to stop the paradox database from locking up and giving me errors during the import process of this database. I then link to these files at a pre-determined location on a local computer hard drive.
When I try to run the code below I get the error about the table being
locked by a user or process. As you can see I have tried adding a pause
incase the files are still being copied but this does not seem to be the
problem.
I have used a msg box to confirm that the copying process has completed before starting the make query, but the same error comes up after I click ok.
Can anyone suggest anything else.
As you can see from the simplicity of the code below I am a beginner so take it easy on me, by not taking knowledge for granted. :)
code:
------------------------------------------------------------
Dim response
Dim stDocName As String
Dim stLinkCriteria As String
response = MsgBox("Are you sure that you want to update xxx with Customer
data from xxx?", vbYesNo, "Perform Update")
If response = vbYes Then
‘pause software to let any pending work to be completed
Sleep (5000)
‘close active form
DoCmd.Close
‘close all active forms
Do While Forms.Count > 0
DoCmd.Close acForm, Forms(0).Name
Loop
‘pause software to let any pending work to be completed
Sleep (30000)
‘delete existing file
Kill "c:folderfile DATA.DB"
‘replace with new file
FileCopy "J:Folderew_DATA.DB", " c:folderfile DATA.DB "
‘pause software to let any pending work to be completed
Sleep (40000)
DoCmd.SetWarnings False
stDocName = "Make_DATA"
DoCmd.OpenQuery stDocName, acNormal, acEdit
‘pause software to let any pending work to be completed
Sleep (35000)
stDocName = "Make_DATA_SUMMARY"
DoCmd.OpenQuery stDocName, acNormal, acEdit
‘pause software to let any pending work to be completed
Sleep (35000)
stDocName = "qry_Update_ Status"
DoCmd.OpenQuery stDocName, acNormal, acEdit
‘pause software to let any pending work to be completed
Sleep (35000)
‘open up main form when finsihed
stDocName = "main-form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.SetWarnings True
Else
End If
I have a database that has all the employees in my company with basic information. I have a auto number set up for each person. I also have on my form a subform with information about the employee's history in the company. I have bin trying for the last couple weeks, to put a button on my form, that will open up the custom report I made for the one employee, in print preview mode. Everything I have tried gives me a error. The main error I get is The database engine could not lock the table "EmployeeT" because it is already in use by another person or process. If I open the report by itself, then I get all my employees. I am looking to just open a single report from the form I am currently looking at.
I have 2 tables. One Named EmployeeT with all the employees basic information. I have a auto number with the field name EmployeeID. The 2nd table is called IncidentT, which has its own auto number, and records all the problem/incidents with the employee. For example, lates, if the did not show up, or cancelled out of that day, etc. I have the 2 tables sharing the EmployeeID, sharing the relationship. My main form, has a lot of my information and a subform, Like i said. what I try I can get rid of that error.
The only way I got it to work without the error, is when I go into properties and change the Record Set Type to Snapshot on both the form and subform. But then I can't edit the form or subform anymore.
I have a database that has all the employees in my company with basic information. I have a auto number set up for each person. I also have on my form a subform with information about the employee's history in the company. I have bin trying for the last couple weeks, to put a button on my form, that will open up the custom report I made for the one employee, in print preview mode. Everything I have tried gives me a error. The main error I get is The database engine could not lock the table "EmployeeT" because it is already in use by another person or process. If I open the report by itself, then I get all my employees. I am looking to just open a single report from the form I am currently looking at.
I have 2 tables. One Named EmployeeT with all the employees basic information. I have a auto number with the field name EmployeeID.
The 2nd table is called IncidentT, which has its own auto number, and records all the problem/incidents with the employee. For example, lates, if the did not show up, or cancelled out of that day, etc. I have the 2 tables sharing the EmployeeID, sharing the relationship. My main form, has a lot of my information and a subform, Like i said. But no matter what I try I can get rid of that error.
The only way I got it to work without the error, is when I go into properties and change the Record Set Type to Snapshot on both the form and subform. But then I can't edit the form or subform anymore.
Hi
I know this sounds stupid but on my database with user-level security, i have somehow managed to remove administer rights from all users , and do not know how to change it back, if it is even possible.
I think what might have happened is it was stored on my USB drive and i switched computers and opened the db, would that have affected it? :confused:
Is there an easy way out of this or am i screwed? :eek:
thanks, ian :)
I have been following a text book to try and secure a database, i set up the Work Group Info File, allocated a password, now even when i want to start a completley new database i have to enter a password.........
AND when i set up the password i must have enetered it wrong now i am completely locked out!!
Is there any way to fix this i cant do anything!! I cant even start on a completely new databse!!
Please help
undefined
Hi, can anyone help? Like an idiot I veered away from my intention to put a password on an Access database which holds only a table and a few queries and explored other security options. I now cannot get in to the database at all and get a message telling me that I do not have the necessary acces srights and to consult my administrator. When I look at the properties, I am shown as the administrator, which makes sense but despite trying various, desperate things, I cannot get back in to take the security off. Needless to say I did not create a copy first, so have learned a lesson the hard way. Any advice gratefully received.
i have this database with tables i can't access, so i had to import the data into a new database , given the size of the new database JoeCruse (form this board) pointed out that it could be that the front end is separated form the back end. and i can't find the front end anywhere
i want to press F11 and see the tables and so forth open up when i launch the original db. how do i go about doing that.
:eek: security levels were set on a database using the wizard, unfortunately the person who set the security did not print out the sheets with the WID etc on it, this person is now unable to open access at all from their pc it asks for a password which the user does not believe they set or if they did set one it was their standard pc log in, however the database and access can be opened from any other pc on the network......can anyone out their help...thanks
View 2 Replies View RelatedAre all mde files locked so that you cannot edit or see design view for forms etc?
Are there any tools out there that can unlock an mde database?
Thanks,
Dave
I have a database that I password protected. Somehow, in the process of applying the password, the file became corrupted and now I am getting the following error message:
"This database is in an unexpected stat; Microsoft Office Access can't open it.
This database has been converted from a prior version of Microsoft Office Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state."
Does anyone know what this error is and how I can retrieve my data?? I have tried to import the files into a new database, convert the database into a different version and compact and repair. Nothing has worked. I have looked into recovery tools and two of them do get me into the database and let me see some of the data, however, the programs are holding my information hostage until I purchase the software which is running around $300.00. Any ideas???
I recently split my database and created an MDE file. Users were given a copy of the MDE file and the BE is in a shared directory on a server. There are only two users at this point in time inputting data into the database (there will be at least a dozen more in the near future), but every so often one of them experiences being unable to input data from their Form because of this lock condition. Sometimes the condition will go away (if they wait long enough) and they can input data again. Sometimes it's User A experiencing the lock, sometimes it's User B. I thought splitting would alleviate lock issues, but it doesn't seem to be the case for me. Could this be a "permissions" issue on the shared directory where the BE is located or some security setting within Access (or both)?
Thanks in advance for everyones help!
Michael
I copied Odun's post below to describe my problem. I'm having the same problem. I can't even creat a new blank database without being prompted for my user name and password, which aren't working.
Any suggestions would be very much appreciated.
Thanks,
Mike
-------------------------------------------------------------------------
#1 02-13-2006, 04:33 AM
odun
Registered User Join Date: Apr 2005
Posts: 108
can't log on to database
Hi all,
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
Please help
Thanks!
odun
View Public Profile
Send a private message to odun
Find all posts by odun
Add odun to Your Buddy List
--------------------------------------------------------------------------
Hi
Is there anyway of returning the menus that I removed from the Tools > Startup options back?
It looks like I have locked myself out of my FE!!!!
Thanks,
B
Hello out!!
Is a moment of desperation! I created a security group or something (dont know what i was thinking!), and now there is no way to get into my application!!!! It says to contact with the administrator, but I'M the administrator!!!!
Any way to get the scripts minimun from the applications?? The classes, the modules??? God!!!! My last backup was 4 days ago!!!! I can't loose everything!!
Message:
you do not have the necessary permission to use myapplication.
:confused::confused::confused::confused::confused: :confused:
I have two db's a front end and a back end db. One of my users recently got this error "Could not update currently locked" Access "3218". I have a form tied to a table. She changed a drop down that puts an ID in the table row and the error occurred. This has never happend before and the locking is set to "No Lock". She swears nobody else was in that specific form either. How does this error occur out of no where? I did add 3 new columns to that table for a total of 30 columns. The front end is local and the back end is on a shared drive. Honestly if anyone can help I would be so so greatful. There is no code used to update this row in the table. As soon as she hits the drop down the new row is created in the table.
Thank You
Jerry
Hi there
I really hope someone can help me.
I used a test database to work on security. I didn't think it would effect other databases. Now I've locked myself out and can't open any databases. I keep getting asked my logon and password for ALL databases.
What can I do? I don't understand why it's effecting me using all databases. Everytime I type a username and what I believe to be the correct Password it wont let me in
Help...
Afternoon all,
I have another account on this forum - dickohead, but I am unable to post or reply to any topics with it.
Can someone please help me with this?
Dickohead.
I have a quick question. I have a database that is split into the front end and the back end. The back end is stored on a network drive and the front end is housed on several different employees' hard drives. It was my understanding that splitting the database would prevent messages such as "Could Not Update; Currently Locked". However, I am still receiving this message. Is there something that I can do to prevent this error from occuring?
View 6 Replies View Relatedi have an access database in lan and when 2 users are working in the same form and in different record the record will be locked
ex if the first user is changing the date in the fist record the second user cant change another record
http://briefcase.pathfinder.gr/download/adi32/2976/399219/0/test.zip
to check open together the forms table1 table1b and try to change two different records
thank you
I have 4 yes/no check boxes on a form. There are 4 other text fields with each one of these main yes/no check boxes. One of these yes/no checkboxes will be checked on each form created.
-------------------------------------------------------------------------------------------
StaPrimary FirstName LastName VerifyDate ReVerifyDate
StaUp FirstName LastName VerifyDate ReVerifyDate
StaBack FirstName LastName VerifyDate ReVerifyDate
StaOther FirstName LastName VerifyDate ReVerifyDate
-------------------------------------------------------------------------------------------
For each new form created I want all 4 checkboxes and its corresponding 4 fields unlocked/enabled.
When any one of the 4 main checkboxes is true, I want the other three and and the 4 text fields that go with them locked and/or disabled.
When I page back and forth between forms I want each form to have the appropriate fields locked/unlocked and or disabled/enabled depending on which main yes/no check box is checked.
I had presented this issue in the past and was never able to solve the issue.
Thanks for any help.
I do not get this, can anyone come up with an idea or area that I could look into. There were fields that the sales reps could write notes into, they are not able to type in these fields anymore. I had a back up copy of the DB prior to this event happeneing. I compared the field in design view and all the values are exactly the same. But the Prior version I can still type in, the newly updated version I can't.
I tried copying the field from the DB where it worked and pasting it where the one not working was, and that didn't work. So, I got to believe there is a GLOBAL lock somewhere available. Unfortnately, the books I have do not discuss this situation at all.
Does anyone have any ideas...I have to think this is an easy fix, but I can't figure it out.
Thanks!
Sorry, i'm an access noob.
I have an ADP with a form in it, the form was working correctly until an ex coworker did something to it.
Now the form is locked, when you goto form view you can only view information. You cant edit or add new records, all the fields are locked.
How do I undo this?
I'm having another issue. I've setup a tracking db that is
shared over a network, but we are experiencing an issue
where the tables are always locked. I've setup a entry form
to the main table. It is a command button that runs off a macro to
open the form that goes to the last row to add the new record, but due to the
number of requests, it is always locked.
Is there a better way of doing this? I've set the db to Shared,
but it is not solving the problem. I need to resolve this ASAP, many
people are upset!! The fields I have are date, time, part number, sales order,
and qty.
Any help will be appreciated.
Thanks in advance,
jymaly
heh...... I went and did it now......
I created a new security group for a database, just for test purposes. It worked great, until the .mdw file got deleted by accident. I can log onto the default system.mdw file, but now I can't create any data access pages in which a new record can be created...... not even on a brand new database.
Say I create a new database, and make a table with one field. Then, I use the data access page wizard using that table, and create the page....... well, when I run it, it says it is a read only database. I've looked at permissions for admin under the default .mdw file and admin should have full access. Any ideas?