Solved

Access 2010 Security and Lost Password

Posted on 2011-09-27
3
239 Views
Last Modified: 2012-05-12
I have a database I originally created in 2003 then successfully migrated to 2007. Now, with Access 2010, I'm trying unsuccessully to open the db. I'm pretty sure I have the correct password and username.

However, when I try to log in, I keep getting an "incorrect password" message.
0
Comment
Question by:dplearning
3 Comments
 
LVL 12

Expert Comment

by:viralypatel
ID: 36709910
1. remove the password protection from the 2003 version.
2. Migrate to 2010
3. recreate the password
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 36710135
<<However, when I try to log in, I keep getting an "incorrect password" message. >>

 Sounds like your using User Level (Workgroup) security rather then a simple database password.  Make sure your starting the DB with the correct workgroup file with the DB using the /wrkgrp switch in a shortcut on the command line.

Jim.
0
 

Author Closing Comment

by:dplearning
ID: 36711622
Thanks JDettman,

You're right. I needed to join the workgroup first.

I was able to open Access 2010, type Ctrl + G (to open a VB window) and Type: "Docmd.RunCommand acCmdWorkgroupAdministrator" This allowed me to start the Workgroup Admin Wizard and let me join to my .mdw workgroup file.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now