I cannot open a Access 2000 database in Access 2007

[John Mitchell]

I have an Access 2000 database running in Access 2003 using a WorkGroup with
a password. When I try to open this database in Access 2007 I get a message
that says: "You do not have the necessary permissions.... etc... contact your
administrator." I have a stand alone computer and I am the administrator as
far as I know.

Seems like my Access 2003 program has been deleted and since I have only got
Access 2007 now I cannot open this important file.

Can anyone help me?

 

[Rick Brandt]

I have an Access 2000 database running in Access 2003 using a
WorkGroup with a password. When I try to open this database in
Access 2007 I get a message that says: "You do not have the necessary
permissions.... etc... contact your administrator." I have a stand
alone computer and I am the administrator as far as I know.

Seems like my Access 2003 program has been deleted and since I have
only got Access 2007 now I cannot open this important file.

Can anyone help me?

Have you joined the workgroup used to secure the file? Better yet would be
to use a shortcut that specifies the workgroup file so you don't have to
make it your default.

"path the MSAccess.exe" "path to MDB" /wrkgrp "path to MDW"

 

[John Mitchell]

Rick gave me the following path to a shortcut path to put into the "Target"
that allowed me to get into the file and then I exported all the records into
a new Access 2007. What a lifesaver.

Here is the path: "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\My Documents\JohnSafe\Finance08.mdb" /wrkgrp "C:\My
Documents\JohnSafe\mitch2.mda"/excl

This path gets the older version of Access and then tells it where the file
is and where the Workgroup is too.

Could not have done it without Rick's help.

 

[CodeJester]

I have many mdbs that I need to be able to process with Access 2007. How do
I join the workgroup. I can't find the option that was available with 2003.
Thanks!

 

[Arvin Meyer MVP]

You can join the workgroup in any version by using a shortcut (which you'll
need to change for each database) to the .mdw file that's on the computer.
It could be anywhere, but is most often in C:\Windows\system32\FileName.mdw

Just search for .mdw on the computer and you'll find all of them. You will
need existing privileges, since you don't have access to the creation
process to add a user. If you no longer have the secure.mdw file, you are
going to need to recreate it, and the only way you can do that is with the
PID that created it in the first place. Lacking that, you are out of luck.
You'll need to find and pay to crack the database. Here's a list of security
resources that may help:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm