If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I cannot open a Access 2000 database in Access 2007
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? -- John |
#2
|
|||
|
|||
I cannot open a Access 2000 database in Access 2007
John Mitchell wrote:
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" -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
I cannot open a Access 2000 database in Access 2007
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. -- John "Rick Brandt" wrote: John Mitchell wrote: 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" -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#4
|
|||
|
|||
I cannot open a Access 2000 database in Access 2007
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! "Rick Brandt" wrote: John Mitchell wrote: 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" -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
I cannot open a Access 2000 database in Access 2007
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/downloa...les/SECFAQ.EXE Lynn Trapp's summarization: http://www.ltcomputerdesigns.com/The10Steps.htm KB articles: http://support.microsoft.com/default...;en-us;q165009 http://download.microsoft.com/downlo...-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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "CodeJester" wrote in message ... 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! "Rick Brandt" wrote: John Mitchell wrote: 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" -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|