[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Access 2010 Security and Lost Password

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
dplearning
Asked:
dplearning
1 Solution
 
viralypatelCommented:
1. remove the password protection from the 2003 version.
2. Migrate to 2010
3. recreate the password
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
dplearningAuthor Commented:
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now