Problem Importing Reorts into Access 2007

[JimP]

I need to convert an Access 2003 mdb into a 2007 accdb. The MS-Access
conversion utility has resulting performance issues, such that I need to
import objects manually into the 2007 accdb.

This is a large mdb/accdb with over 10,000 objects - 3,800 of them are
reports. Using the "select all" and import utility, results in an out of
memory error.

The solution is a table of report names, and a code loop to import the
reports - splitting the import into (2) batches.

Now for the problem. The first half of the reports import fine. The second
half appear to import fine. But upon closing and re-opening the accdb, all
reports are missing from the view. They are there but not visible. (this was
working before - the problem is new)

Any ideas on how to troubleshoot, or convert an mdb of this size to an
accdb?

 

[AccessVandal via AccessMonster.com]

Check this site from Tony
http://www.granite.ab.ca/access/performancefaq.htm

Don't see why when converting can cause performance issue. You might want to
consider decompiling first before you do compact and repair.

Look at long names issue that might be the cause.

Are you having problems with the Navigation Pain, sometimes the Nav Pain
hides the objects you may have to click on top of the Nav Pain to select the
type of objects to view.

 

[JimP]

Thanks, will look into these items.

Check this site from Tony
http://www.granite.ab.ca/access/performancefaq.htm

Don't see why when converting can cause performance issue. You might want
to
consider decompiling first before you do compact and repair.

Look at long names issue that might be the cause.

Are you having problems with the Navigation Pain, sometimes the Nav Pain
hides the objects you may have to click on top of the Nav Pain to select
the
type of objects to view.