Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

I cannot open a Access 2000 database in Access 2007

 
   Database Forums (Home) -> MS Access RSS
Next:  Count multiple categories within the same report ..  
Author Message
John Mitchell

External


Since: Aug 19, 2008
Posts: 2



(Msg. 1) Posted: Tue Aug 19, 2008 6:40 pm
Post subject: I cannot open a Access 2000 database in Access 2007
Archived from groups: microsoft>public>access (more info?)

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

 >> Stay informed about: I cannot open a Access 2000 database in Access 2007 
Back to top
Login to vote
Rick Brandt2

External


Since: Sep 30, 2003
Posts: 234



(Msg. 2) Posted: Wed Aug 20, 2008 6:10 am
Post subject: Re: I cannot open a Access 2000 database in Access 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
John Mitchell

External


Since: Aug 19, 2008
Posts: 2



(Msg. 3) Posted: Sat Aug 23, 2008 11:28 am
Post subject: Re: I cannot open a Access 2000 database in Access 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
upgrade pc from Access 2000 to Access 2007 - ee have an access 2000 database that has a password enabled. We just upgraded the pc to Access 2007 and now get "you do not have permission p:\path_to_database for database object" I can still connect from my pc that has Access 2000. I tr...

Access 2000 Runtime with Access 2007 Installed - A couple years ago, I developed an application for a friend, using Access 2000. He's been running it successfully in his office on about 12 workstations which run Office 2000. He's in the process of purchasing new computers for all his employees and..

Help!! I can't open Access 2007 - I think I made a major blunder, and now Access 2007 no longer opens. I made the mistake yesterday of using the "test" option in wise installer for my Access 2007 runtime app. It actually installed the Access 2007 Runtime SP-1 (I did have ful...

Access 2007: How to tell which DB is open? - Hi folks: Where in the UI can I see the filename of the open database? This is especially needed when I have multiple databases open. I was expecting it to appear in the titlebar... and indeed the filename does show in the taskbar blob, but it's..

Access 2007 command buttons do not function - database in .. - Trying to install some software on Access 2007. The software works just fine on earlier versions of Access. I have been told that it works on Access 2007 but I have not seen that personally. The command buttons on my user-created forms do not..
   Database Forums (Home) -> MS Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]