1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: access database

Discussion in 'Business Applications' started by timmycl_7, Jan 28, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. timmycl_7

    timmycl_7 Thread Starter

    Joined:
    Nov 28, 2007
    Messages:
    50
    Hi,

    I have an access database.

    I decided to make a mde file with it out of curiousity. It has now taken my database and password protected it. I never set any password and as such cannot get access to the database.

    It has taken my user name from my login, but it is not using my login password.

    Does anyone know how I can override this, or reopen an older version of the database.

    Thanks
     
  2. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    try a blank password first and if I recall when it makes a MDE it leaves the original file intact still as well.
     
  3. timmycl_7

    timmycl_7 Thread Starter

    Joined:
    Nov 28, 2007
    Messages:
    50
    Hi,

    I used the Tools, Database Facilities, Make MDE File on my access database. Now I have found that it is asking for a password everytime I open MS Access with any database even the northwind database.

    I haven't set a username or password so I'm very confused by this. It is taking my PC login username but not accepting any of the passwords.

    Has anybody encountered this problem before? Or know how to solve it?

    It won't let me open any MS Access Database!

    Thanks
     
  4. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    I could have sworn I replied to this yesterday. ;) Try using a blank password. It typically sets up the accounts with no password if you did not specify one. Also when making the MDE file it typically leaves the original database the way it was. You should still have the original database on your PC somewhere.
     
  5. timmycl_7

    timmycl_7 Thread Starter

    Joined:
    Nov 28, 2007
    Messages:
    50
    Hi,

    I have tried the blank password, it didn't work. MS Access is stoping me from opening any access databases. I have unistalled and re-installed MS Access and this still hasn't worked
     
  6. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    Eh, Are you trying to open the file instead of the application initially? Did you setup a rights and permisions file by going through the wizard?
     
  7. timmycl_7

    timmycl_7 Thread Starter

    Joined:
    Nov 28, 2007
    Messages:
    50
    No, when I open access it come up with the usual dialog box, selected file or create new one.

    I cannot open any file or for that matter create a new one.

    To my knowledge I haven't set up any rights or permissions. Is there any way of checking these If I have.

    I have created any passwords that is what has stumped me!

    Thanks
     
  8. timmycl_7

    timmycl_7 Thread Starter

    Joined:
    Nov 28, 2007
    Messages:
    50
    No, when I open access it come up with the usual dialog box, selected file or create new one.

    I cannot open any file or for that matter create a new one.

    To my knowledge I haven't set up any rights or permissions. Is there any way of checking these If I have.

    I haven't created any passwords that is what has stumped me!

    Thanks
     
  9. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Yep Jim, and I read it: http://forums.techguy.org/business-applications/676895-big-mistake.html

    Timmy, don't double post. It violates the rules of the forum, confuses people and irritates them - after all, Jim was answering the other one, now he is in this one. Which is the one to continue in? What if someone else answers the other?

    I see you are fairly new here...we all make some mistakes, just learn not to do this again.
     
  10. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,086
    Reported. I imagine the mods'll merge them.

    Anyway, I wonder if this has something to do with lock-file craziness. timmycl, how do you know you can't create new files or open saved ones? Is there a message box or something? If so, what does it say?

    chris.
     
  11. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Two things - just in general, reboot...(ya never know...)
    Also, can you open Access at all - not a file, just the program?
     
  12. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,086
    ?

    When'd this get marked solved?

    chris.
     
  13. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Dunno - mods block them, don't they?
     
  14. Cookiegal

    Cookiegal Administrator Malware Specialist Coordinator

    Joined:
    Aug 27, 2003
    Messages:
    111,832
    I've merged them both here but I'm going to have to close this and we no longer assist with password issues since we can't determine the actual situation or intent.

    Please refer to the forum rules:

    Passwords - Please do not ask for assistance with forgotten passwords and/or bypassing them. As there is no way to verify the actual situation and/or intentions, no assistance will be provided and any such threads will be closed.
     
  15. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/677218

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice