"Jim Orson" <jorson@NOSPAMsatx.rr.com> wrote in message
news:eItBIHF8JHA.3804@TK2MSFTNGP02.phx.gbl...
>I am trying to convert an Access 2003 mdb file to an Access 2007 accdb file
>and am having a problem.  Here's what I am doing:
>
> 1. open the mdb file in Access 2007
> 2. click pizza; save as; Access 2007 database
> 3. click yes to "do you want Microsoft Office Access to close the
> objects.?"
> 4. click "save" in "save as" dialog box (with file name as xxxx.accdb)
> 5. at that point I get an error that says "you attempted to open a
> database that is already opened exclusively by user xxx on machine yyy.
> Try again when the database is available."  The only choice is "ok" and
> then the file is not saved as accdb.
>
> What do I do to get past the error in 5 above?  Thanks...
>
> Jim...

"Jeanette Cunningham" <n**@discussions.microsoft.com> wrote in message
news:u1cJRsM8JHA.1340@TK2MSFTNGP05.phx.gbl...
> Hi Jim,
> I find it is easier to create a new database in A2007, turn of name
> autocorrect in the new database and import everything from the 2003
> database into the 2007 database.
>
>
> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
>
> "Jim Orson" <jorson@NOSPAMsatx.rr.com> wrote in message
> news:eItBIHF8JHA.3804@TK2MSFTNGP02.phx.gbl...
>>I am trying to convert an Access 2003 mdb file to an Access 2007 accdb
>>file and am having a problem.  Here's what I am doing:
>>
>> 1. open the mdb file in Access 2007
>> 2. click pizza; save as; Access 2007 database
>> 3. click yes to "do you want Microsoft Office Access to close the
>> objects.?"
>> 4. click "save" in "save as" dialog box (with file name as xxxx.accdb)
>> 5. at that point I get an error that says "you attempted to open a
>> database that is already opened exclusively by user xxx on machine yyy.
>> Try again when the database is available."  The only choice is "ok" and
>> then the file is not saved as accdb.
>>
>> What do I do to get past the error in 5 above?  Thanks...
>>
>> Jim...
>
>

"Tony Toews [MVP]" <tto***@telusplanet.net> wrote in message
news:7bat35ltaeh4r59hb102eglttqbka22bnq@4ax.com...
> "Jim Orson" <jorson@NOSPAMsatx.rr.com> wrote:
>
>>Plus it looks like some formulas don't work.
>
> Give us some details on what's not working and maybe we can help.
>
> Also fellow MVP Allen Browne has some info on A2007 quirks and tips at
> http://allenbrowne.com
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> Granite Fleet Manager http://www.granitefleet.com/