Converting access 2003 to 2007 error

[Andy]

I would like like to convert an Access 2003 database to 2007 format. I need
to attach multiple pdf's to a record and wanted to use the new Attachment
field type in Access 2007 instead of creating a separate table for this
information.

I am on a stand alone pc running Vista Business and Office 2007.

When I follow the "convert" instructions using either the SAVE AS option (or
even the CONVERT), I get this error message which prevents the conversion
taking place.

"You attempted to open a database that is already opened exclusively by user
'Admin' on machine <name>. Try again when database is available."

My Vista User Account is on of administrator.

Any help would as always be appreciated. Thank you

 

[Angie]

I am having the same problem. My 2003 database is split (frontend and
backend), and it is not "Read Only." Thanks.

 

[CB]

I'm having the same problem. I have a 2003 database with tables, queries and
a few macros in it. I have tried this using the file on a network drive (I
have admin perms on the network) and on the local drive. I have closed any
processes that I thought might be from the database being opened. It seems to
me that the conversion process is worthless if it can't be used on a database
that has any complexity at all. If anyone has any more information on this
I'd love to hear it.

CB

 

[Trickett]

We are also having the same issue on a multi user 2003 access DB: we have
opened it on a personal drive, network drive, critix server, renamed it,
reset admin rights. We also tried to import in 2007 but lost functionality
so that isn't an option.

We run off XP and the admin that is referenced is different depending on who
is attempting to convert, but always the same error.

Any help is appreciated

 

[John Satterfield]

I get the same message when I try to "Save" an Access 2003 database "As" a
2007 database.

 

[Thorson]

I am having the exact same problem... apparently no one has found a solution
yet?

 

[John Satterfield]

Apparently not. It appears to be a bug that Microsoft hasn't fixed.

 

[Andrew Scaife]

Hey guys, I may have found a fix (it worked for me anyway....):

- Go to Access Options, Current Database
- Change the Display form to none
- Convert database

Then you can go back to options and reset your display form

 

[John Satterfield]

That doesn't work for me. I wonder what was different about your database.

John

 

[Andrew Scaife]

Hi John,

It appears to have something to do with not being able to properly close
components down. I wonder if yours has linked tables and it isn't able to
shut the connection to those tables? Might be worth deleting the linked
tables temporarily.

Food for thought....

 

[John Satterfield]

Nope, no links. I guess I'll have to wait for Microsoft to fix the problem.

John

 

[Thorson]

That worked for me! Thanks!

Hey guys, I may have found a fix (it worked for me anyway....):

- Go to Access Options, Current Database
- Change the Display form to none
- Convert database

Then you can go back to options and reset your display form

 

[johnsatterfield]

I'm having the same problem. I have a 2003 database with tables, queries and
a few macros in it. I have tried this using the file on a network drive (I
have admin perms on the network) and on the local drive. I have closed any
processes that I thought might be from the database being opened. It seems to
me that the conversion process is worthless if it can't be used on a database
that has any complexity at all. If anyone has any more information on this
I'd love to hear it.

CB










- Show quoted text -

I finally found an easy solution. Set up a blank 2007 database with
the same name (or another name) as the old one. (It will have a
different suffix than the 2007 database, so it won't write over the
old one.) Then click on the External Data tab, and then on the Access
button (in the Import group). The ensuing dialog will ask you which
objects you want to import--select all of them. The resultant 2007
database works just like the old one did/ My relationships work too.

John