Error upsizing a database


A

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.
 
Ad

Advertisements

A

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.....
 
Ad

Advertisements

A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No access to upsized database 1
Upsizing Access Database 5
Upsizing 100 Databases 2
upsizing error 1
Upsizing error 1
Upsizing errors 2
SQL upsize 2 databases 2
Database Corruption and advice on upsizing 9

Top