Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Password problem

Status
Not open for further replies.

ddsf

Programmer
Jul 28, 2000
4
US
I put a password on Access it self because of some of the new internet hacker problems. I had read from one of the security email newsletters it was a good idea. I used my standard password.<br><br>Now after shutting the system down and restarting, I can not open any of my Access MDBs. I have tried the password I gave it with all versions of Caps, non-caps. How can I get out this mess?<br><br>Thanks
 
I am definitely not a security expert, but can you replace your sysem.mdw file?? <br><br>Go into Workgroup Administrator (probably at C:\WINNT\SYSTEM32\WRKGADM.EXE) and see what workgroup you belong to.&nbsp;&nbsp;If it is the system.mdw file on your harddrive, see what happens if you try to open the files from someone else's machine.&nbsp;&nbsp;If you can open it from someone else's machine, then you should be able to open on yours if you copy their system.mdw file. <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>
 
Hi, I looked at that, and even renamed the file, It did not do anything to access. I still get asked for a password as Administrator (which is how I run). But the password I remember (and always use, bad habit), does not work. I need to get Access to forget I put a password on it.<br><br>Thanks for the help.
 
Don't replace your system32, it won't work.&nbsp;&nbsp;In fact, this will make your matters worse.&nbsp;&nbsp;If you haven't replaced it, try signing in as Admin with no password.&nbsp;&nbsp;If you've already done that, then you've destroyed the only copy of what permissions are allowed to whom.&nbsp;&nbsp;If you've replaced the system32, here's what I would suggest, there's hope yet.&nbsp;&nbsp;Make sure that your system is set to system32 in the windows directory.&nbsp;&nbsp;This is the generic permissions file provided by Microsoft.&nbsp;&nbsp;Once you've done that, create a new database then start importing the information from the old database.&nbsp;&nbsp;This will create the information in the new database without the old permissions you've set to it.&nbsp;&nbsp;Then I would suggest you read up on security measures a bit more and practice with a dummy database.&nbsp;&nbsp;The key is setting yourself as admin.&nbsp;&nbsp;Put simply, you have to create you account while signed in as the Admin account; set your name, acct., and password; then set your permissions.&nbsp;&nbsp;This process is best done while a database is being created.
 
Hi, Thanks for your response, I did not replace the system32 thing. So everything is still there. But I can not even open a new Access database. I always get asked for a password (with a default Administrator name). None of my usual passwords work. I was sure when I did the password thing a couple a days I used my standard, but all combinations of caps etc fail. So I am unable to get to access at all except to open the program.<br><br>Please I still need help. Could I uninstall Acess and reinstall it?? Would that wipe on the password?<br><br>Thanks again for responding.<br><br>
 
I am sure if you sign on as Admin and your password then you will get it open like the person said above this last message.&nbsp;&nbsp;Otherwise, I would delete the file associated with the db security system.mdw.&nbsp;&nbsp;I have done it before but this wipes out all the old passwords you saved and user permissions.&nbsp;&nbsp;You will have to start fresh!&nbsp;&nbsp;Otherwise if you remember what the Admin password is, given that you didn't change the Admin user name, and if you did change that Admin name then you will just have to keep trying. Goodluck
 
Email a copy of your mdw file to me. I have software that will break all the passwords. I will email you back with the results.<br><br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>
 
Correct me if I'm wrong, but I believe the default user that is first created upon setting security for Access is &quot;Admin&quot;.&nbsp;&nbsp;If your trying to get in using &quot;Administrator&quot;, that may be why the password doesn't work, because the username may not exist.&nbsp;&nbsp;Try that and see if your password works.
 
Hiya,<br><br>What process did you go thru to protect the all of Access from internet hackers?&nbsp;&nbsp;<br><br>I'd see if you could take a clean system.mdw file from somebody elses machine without workgroup security.&nbsp;&nbsp;Install is in a directory other than the windows/system directory (ie dont overwrite) and open a new database using command line switches <br>like <br>&quot;C:\Program Files\MSOffice\Access.exe&quot; &quot;C:\Windows\Desktop\Temp.mdb&quot; \wrkgrp C:\Windows\Desktop\NewSystem.mdw<br><br>HTH,<br>Drew
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top