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
>
>
> >> Stay informed about: I cannot open a Access 2000 database in Access 2007