Access 2007 SQL Conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Many thanks, I should have tried that before posting (forgot all about the
shift key)

Many thanks again
 
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
 
Back
Top