Error upsizing a database

[Artificer]

I have tried on several occasions to migrate the Northwind 2007
database to a SQL Server 2005. I have also choose to generate a
new .adp associated to the new SQL Database. I keep getting the error:

UT_HandleADPForms You already have an open database object named '|.'
2007

The migration continues but at the end the forms can’t connect to the
data.
I am doing this as a migration test. Anybody can give me any inside
about this error? Anybody has been able to upsize the Northwind 2007
database and generate an .adp?

I get the same error trying to migrate any of the sample databases and
I get the same error on different computers where I have tried it.

 

[Albert D. Kallal]

I am doing this as a migration test. Anybody can give me any inside

about this error?

I just tried upsizing the northwind and it upsized without errors. So,
BEFORE you start the upsize, I would first do a compact and repair. The
second thing is MAKE SURE that no startup code or forms etc. are loaded.
(hold down the shift key during database startup to prevent any of the
startup forms and code running

(if you think about this for a second it makes no sense to allow the startup
code and macros etc. to start running. And, then after all that stuff
loads/runs, then you can't expect the upsize to function correctly while you
have had forms and code running or loaded. So exit the database, and when
you re-open it, hold down the shift key to prevent any startup code and
"parts" of the application loading and running.

Of course after I upsized to a adp project there is a macro error with the
startup macro, but that's another matter. (I'm sure playing around with a
macro for big guy could figure out what's going on, unfortunately though I
never used access macros, so I'm not sure what the problem is).

Regardless, at the end of the day you really don't want to have any forms or
code or anything in the application loaded or running when you attempt to
upsize.....

 

[Artificer]

about this error?

I just tried upsizing the northwind and it upsized without errors. So,
BEFORE you start the upsize, I would first do a compact and repair. The
second thing is MAKE SURE that no startup code or forms etc. are loaded.
(hold down the shift key during database startup to prevent any of the
startup forms and code running

(if you think about this for a second it makes no sense to allow the startup
code and macros etc. to start running. And, then after all that stuff
loads/runs, then you can't expect the upsize to function correctly while you
have had forms and code running or loaded. So exit the database, and when
you re-open it, hold down the shift key to prevent any startup code and
"parts" of the application loading and running.

Of course after I upsized to a adp project there is a macro error with the
startup macro, but that's another matter. (I'm sure playing around with a
macro for big guy could figure out what's going on, unfortunately though I
never used access macros, so I'm not sure what the problem is).

Regardless, at the end of the day you really don't want to have any formsor
code or anything in the application loaded or running when you attempt to
upsize.....

Your suggestion did help. However after migration many of the forms
dont work. For example the "customers details" form generates the
following error: "The Record Source 'Customers Extended' specified on
this form or report does not exist. Several other forms failed with a
similar error.