Solved

Access 2010 Security and Lost Password

Posted on 2011-09-27
3
244 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How can you open the FORM2 2 31
Access 2016 7 33
Location of files for Quick Access Toolbar (QAT) settings in Office 2010 3 35
Run SQL Server Proc from Access 11 30
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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