I'd like to convert an Access 2000 that i had on an xp machine to an Access
2007 database on my new Windows 7 machine. Whenever i attempt to either 'Save
As' or 'Convert' I get a message that the database is already opened
exclusively by the 'Admin' user and to try again when the database is
available. What am i doing wrong?

Thanks for the help.

On Tue, 29 Dec 2009 13:15:01 -0800, BudinPA
<(E-Mail Removed)> wrote:

>I'd like to convert an Access 2000 that i had on an xp machine to an Access
>2007 database on my new Windows 7 machine. Whenever i attempt to either 'Save
>As' or 'Convert' I get a message that the database is already opened
>exclusively by the 'Admin' user and to try again when the database is
>available. What am i doing wrong?
>
>Thanks for the help.

Try creating a new, empty database and use File... Get External Data... Import
to import everything from the 2000 database.
--

John W. Vinson [MVP]

Hmmm.....

Try opening your database holding down the Shift key the entire time that it
is opening. Then try doing the conversion, before opening any objects.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"BudinPA" wrote:

> I'd like to convert an Access 2000 that i had on an xp machine to an Access
> 2007 database on my new Windows 7 machine. Whenever i attempt to either 'Save
> As' or 'Convert' I get a message that the database is already opened
> exclusively by the 'Admin' user and to try again when the database is
> available. What am i doing wrong?
>
> Thanks for the help.

when the db is closed. do you see an .ldb file for it still existing?


"BudinPA" wrote:

> I'd like to convert an Access 2000 that i had on an xp machine to an Access
> 2007 database on my new Windows 7 machine. Whenever i attempt to either 'Save
> As' or 'Convert' I get a message that the database is already opened
> exclusively by the 'Admin' user and to try again when the database is
> available. What am i doing wrong?
>
> Thanks for the help.

Thanks, Tom. The shift key did the trick. I appreciate your help.

"Tom Wickerath" wrote:

> Hmmm.....
>
> Try opening your database holding down the Shift key the entire time that it
> is opening. Then try doing the conversion, before opening any objects.
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> __________________________________________
>
> "BudinPA" wrote:
>
> > I'd like to convert an Access 2000 that i had on an xp machine to an Access
> > 2007 database on my new Windows 7 machine. Whenever i attempt to either 'Save
> > As' or 'Convert' I get a message that the database is already opened
> > exclusively by the 'Admin' user and to try again when the database is
> > available. What am i doing wrong?
> >
> > Thanks for the help.