Error converting 2003 to 2007 - "File Already in Use"

[Digman]

I have been trying everything to convert a MS-ACCESS 2003 file to 2007.
Everytime I try I get the error

Could not use 'C:\DB.mdb'; file already in use.

I have tried re-booting.

I found this article that I thought would help:
http://support.microsoft.com/default.aspx/kb/289681

This says it is caused by user rights on the folder. This can't be the
problem. I have full access.

I would appreciate any help.

 

[Arvin Meyer [MVP]]

It may be a misleading message telling you that you are trying to use the
same filename as the original file.

 

[Digman]

I Tried using a completely different name for the 2007 DB - I still get the
same error.

 

[Arvin Meyer [MVP]]

I should have mentioned that using the Access 2000 through 2003 formats work
perfectly well in Access 2007. Indeed, I only use the 2000 format for the
data back-end for that reason.

Blocking file creation is not a function of Microsoft Office, or MS-Access,
it is a function of the operating system. Try rebooting and look for the
existence of DB.mdb in the root of the C:\ drive. Make sure that you have
your file extensions showing, and I'd also suggest turning on the Show
Hidden Files option.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Digman]

I realize Access 2003 format still works, however since I paid for 2007
upgrade there are new feature I want to use.

I have tried re-booting several times, I have tried several differrent file
names, there is no way the file already exists.

The Access 2003 DB used the Object Level Security, which is no longer
supported in 2007. I wonder if this could have something to do with the
error I am getting?

 

[Arvin Meyer [MVP]]

I realize Access 2003 format still works, however since I paid for 2007
upgrade there are new feature I want to use.

I have tried re-booting several times, I have tried several differrent
file
names, there is no way the file already exists.

The Access 2003 DB used the Object Level Security, which is no longer
supported in 2007. I wonder if this could have something to do with the
error I am getting?

Access 2007 supports User-Level Security for the MDB format, but that's not
the reason that you are having this problem. The operating system will not
let you name 2 files with the same name and extension. Try creating a brand
new empty file and importing all of your objects.

 

[Digman]

I have read about this too, and was thinking about doing it, but that would
get rid of my user-level security. Also in my "relationships' window, I have
over 200 tables linked. How do I copy this?

 

[Digman]

OK I think I figured it out.

I have a macro that is named autoexec that runs everytime I open the
database. The first thing it does is to run the 'WindowHide' command, which
hides the main database (Navigation Panel) and then I run an OpenForm command
to open my MainMenu form.

If I allow this to run, then I close the mainmenu form, and try to convert I
get the 'file already in use' error.

If i prevent the Autoexec from running by opening the database while holding
down the Shift key when I launch it, then run the 2007 conversion it worked
fine.

Thanks
Dave

 

[Arvin Meyer [MVP]]

You will lose User-Level Security anyway if you change the file format to
ACCDB, as this isn't supported. So to maintain ULS, you need to stay with
the MDB format. That precludes using most of the new functionality of Access
2007.

When you import into a new MDB, you can import the relationships as well. As
a matter of fact, that's the default.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com