2007 v. 2003

[FunOne]

I have this database made in Access 2003. It contains some subforms on
a mainform. Works ok in Access 2003, opening instantly. BUT opening
this database in Access 2007 Access 2007 is calculating fields for a
long time (some 15 seconds) eventually showing everything ok. Why is
this happening?
Tried converting the database to Access 2007 format but same problem.

 

[Guest]

I have experienced this and other issues after conversion to 2007 from 2003.
I do not know the cause, but all seem to be resolved by creating a2007 and
importing the objects from 2003. Check your import specs and options to bring
in the relationships and menus.

If you have menus in the 2003 version, you have the option to import them
and will find these in the Add Ins menu of the 2007 version. Once in, you
cannot edit or remove them, (as far as I can figure) so I have chosen not to
import the menus and custmised the Ribbon for my users.

Perhaps someone knows why the conversions presents this problem and how to
overcome? If not, create and import is easy enough.

Ps
The "other isuues":

Some code where Me! is used stopped working.
Code to print reports stopped working but I figured I was taking shortcuts
by not specifing all criteria, even ommited the "" place holders in some
cases (early, very early attemts at design with code).
Speed, but not just on opening.
In one case, all the code behind forms and reports had disappeared,
absolutely nothing in the VBA project. (Back up copies before the conversion
saved me)

 

[FunOne]

Tried creating a2007 and importing the objects from 2003. But still
it's "Calculating . . . " for a looong time upon startup. It's
calculating subforms value's. These subforms, opened exclusively for
themselves, calculates the value right away.

J. Hollstén

 

[Guest]

I have to leave this to the experts.

Sounds like the structure/content of the underlying queries or too many
calculated fields when the forms are all opened at once, (since they
calculate fast when opened individually) but I am not sure about this
suggestion.

 

[FunOne]

I have to leave this to the experts.

Sounds like the structure/content of the underlying queries or too many
calculated fields when the forms are all opened at once, (since they
calculate fast when opened individually) but I am not sure about this
suggestion.

Yes, but funny that in 2003 they are calculated (almost) instantly.

Anyone tried migrating/ converting an Access project to Visual Basic
with some of the available tools out there?

J. Hollstén

 

[Paul Shapiro]

Someone else posted that setting CanGrow and CanShrink (in the form's Detail
band) to No dramatically increased display performance in Access 2007.

Tried creating a2007 and importing the objects from 2003. But still
it's "Calculating . . . " for a looong time upon startup. It's
calculating subforms value's. These subforms, opened exclusively for
themselves, calculates the value right away.

J. Hollstén

 

[FunOne]

I read that lot's of people shares this same problem; access 2007
totally poor performance opening databases made in earlier access
versions. What are we missing? Anyone sorted this out? Any folks at
Microsoft reading this? Help..