Access 2007 SQL Conversion

[Guest]

I am trying to convert an Access 2007 database to SQL. I keep getting the
error "Upsizing wizard cannot run with any database objects open". But it
does not tell me what is open and how to close them. As far as I am aware you
can only run the Wizard with the database open. Is there another way?

 

[Guest]

You are right, the db has to be open. What it is trying to tell you is that
there might be an object open. This could be a form which is in hidden state
or not visible state. What you can try do do is open the database from the
explorer with the shift-key pressed, this will bypass any startup options.
Then try running the wizard again.

hth

 

[Guest]

Many thanks, I should have tried that before posting (forgot all about the
shift key)

Many thanks again

 

[Guest]

This was the hint that I needed also. My problem was with converting DB from
access 2003 to 2007. It kept telling me that the file was already open
exclusively. I had a startup form in my app and before converting, I simply
closed the form. This was obviously not enough. Some process must have still
be running. Opening the DB with shift got the conversion working perfectly.

Thanks