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.
: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
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 --------------------------------------------------------------------------
I have an access application which is locked for edit. When ever i open this application it shows me the main menu, i want to edit this menu but it does not give me any option, even the Access File menu and toolbars are not visible. Please help
I have a MS Access 97 database that seems to be locked. I wish to update it but I cannot open it as a regular file. When it is opened, there is no way to edit the database or access any of the controls that are usually present. The tool bars are even different.
I am using OLEDB to connect to an Access DB and it does use the "admin" account as the default user to connect from within Access i.e. this is not a Windows account.
I have an ASP.NET web page that is trying to do a compact and repair using a jet/MDAC object called JRO (Jet Replication Object).
The problem is whenever I call the JRO object I get this error:
"You attempted to open a database that is already opened exclusively by user 'admin' on machine..."
If I try and delete the .ldb file it is ofcourse locked. I found that if I do a CTRL-ALT-DEL and end the aspnet_wp process I am then able to delete the .ldb file and then successfully execute the compact and repair from the ASP.NET web page.
The aspnet_wp process when ended simply restarts itself (a new instance no doubt) and in doing so cannot remember it had a lock on the access db.
My conclusion is that the aspnet_wp process locks the access db file for or on behalf of the "admin" user in the access db.
Even if all connections have been closed the aspnet_wp process has a lock on the database file!
I am still searching for a way to tell the aspnet_wp to let go of the access db file!
I did use getprocessbyname() from the ASP.NET page to try and kill the instance of aspnet_wp programmatically and try and force it to forget by starting a new instance of itself, but ofcourse IIS gets really upset and won't let me kill this process from an ASP.NET page because I figure that in this case its suicide and aspnet/IIS won't "kill" itself but would be happy to "kill" other processes.
Anyway, I would have been content with the "kill the aspnet_wp process instance" approach except it won't suicide.
Does anyone have any idea how I might tell the aspnet_wp process to let go of the acccess db file?
By the way, I found the only account you need in a dev environment is the ASPNET account with read/write access and also your own account if you want to browse the folder yourself. No other accounts needed.
Any ideas appreciated.
I think this one has me beaten
from howartthou Windows XP Prof. VS.NET 2003 IIS 5.1
Basically, I have 3 forms which have all got the properties set to DISALLOW right clicking on them to prevent users accessing the design of the form, they all have code behind them so that they cover the entire screen and block ALL menus/shortcuts apart from those available on the form and I have set up a command button on each form which is password protected to ONLY allow Admins to access the design/backend of the form/database when they enter a valid password.
However, I was playing around with the settings of all these forms and have inadvertantly locked myself out, the last thing I remember doing was setting up a "Password" form to collect the Administrator password which had code attached to allow access to the database design. This was working fine until I tried "tweaking" it and now whenever I input the CORRECT password, I get the error message;-
"Error 2585: This action can't be carried out while processing a Form or Report event"
If I enter an INCORRECT password, I get the standard "Login Failed-Please try again" form that I have set up.
The "Password" form doesn't have an override/Cancel (I wanted to make it REALLY secure) it means that although I can use the database fine for entering/editing information/data within the database when it first opens, as soon as I want to make changes to the design and try to log in with "Admin" privellages using my custom made "Password" form, it then pops up with the password screen and goes no further.
I do have a backup of this database BEFORE I set up the "Password" security to collect the "Admin" Password but I can't remember the code I used and although I can work it out again, it will take me a LONG time to work it out again. So I was wondering if any of you might have some ides or a workaround I could try to gain back "Admin" rights to my database.
Does this makes sense? As stated I do have a backup so if all else fails I'm going to have to try to remember how I got it working in the first place BEFORE I cocked it up but if any of you could save me the trouble that would be very much appreciated!
I've just tried adding the Administrator to a workgroup as described in http://support.microsoft.com/kb/918583 and now I can't open any access databases at all!
It's asking me for Login Details even on a blank database.
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.
1/ At work, I have Access 2000 application residing on a Novel server for multiusers purpose. Everyday, occasionally, the application is locked out by whoever opens first (I think?). Some of other users could not open it since it has the message like "locked out by a particular (computer name)...". Therefore the user of that computer name needs to close the application so others can open it. This issue is not happen in Access 97 as we used that version before and it is not consistent happening, so I could not find the pattern or know why?? Please let me know if you have seen this problem and how to prevent it...
2/ Do we have a way to trigger or initiate GroupWise email inside an Access 2000 application. For example, if a purchase order is created in Access 2000 application, I want to email a co-worker...OR it can be automatically sent an email to my supervisor for notifying the purchase order so he can approve it?
Thanks so much in advance for all the helps... Access2k
I have MS access database. The database is password encrypted. I do not own this database but it is critical for me to see the contens of this database. I do not want to edit the contents.
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:
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!!
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.
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)?
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.
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
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?
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'
i 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
