Subform Totals Very Slow Access 2007

Hello Everyone,

I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).

The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.

Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals). Under
Access 2003, this was perhaps under 1 second, basically instant. I've
compacted the database, I've compared properties with forms/controls
etc that work Ok. I can't work it out!

I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at all.
(ie, put msgbox(InvoiceTotal) in the form's OnCurrent Event, which
gave BLANK/Null display).

Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display the
Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
as long to display the form Totals. Basically, the XP/2003
Terminals give the totals instantly like they should.


I'm interested to hear from others. I've searched high and low, on
Forums, google etc.

Totally weird.


Thanks for listing! Any similar experiences or resolutions, I'd love
to know!


Elias Farah.

Re: Subform Totals Very Slow Access 2007

elias.farah@scw.com.au wrote:

> Hello Everyone,
>
> I'm having some very weird behavior on a couple of Access forms. (Not
> all forms, just some of them).
>
> The forms have been working for years, under Access XP/2003 etc, and
> last week upgraded from Windows XP/Office 2003 to Vista x64/Office
> 2007.
>
> Under Access 2007, a couple of forms are now taking 60 seconds to
> calculate a total field in a subfoirm. (ie, Invoice Totals). Under
> Access 2003, this was perhaps under 1 second, basically instant. I've
> compacted the database, I've compared properties with forms/controls
> etc that work Ok. I can't work it out!
>
> I Initially thought there must be some change in 2007's form
> properies, as I thought the total was just not calculating at all.
> (ie, put msgbox(InvoiceTotal) in the form's OnCurrent Event, which
> gave BLANK/Null display).
>
> Ok.... When I updated to Vista/Access 2007, Some of the terminals
> remained (and still do) on Access 2003. These terminals display the
> Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
> as long to display the form Totals. Basically, the XP/2003
> Terminals give the totals instantly like they should.
>
>
> I'm interested to hear from others. I've searched high and low, on
> Forums, google etc.
>
> Totally weird.
>
>
> Thanks for listing! Any similar experiences or resolutions, I'd love
> to know!
>
>
> Elias Farah.
>
Not having any experience with 2007, I'll toss in my two cents. With
such a radical change in speed from 1 second to 60 seconds, somethings
wrong. I'd also wonder why a field calculation is taking one seond in
the previous system, can that be speeded up? Maybe 2007 is more strict
in 2007 and looser in 2003 on some process you are doing in the
calculation? Could you roll something up here, tuck something there
that could make the calc fly? IOW, maybe you need to rewrite the
calculation, maybe a couple of more queries to speed it up?

Re: Subform Totals Very Slow Access 2007

On Sat, 20 Oct 2007 17:14:56 -0700, elias.farah@scw.com.au wrote:

Just out of curiousity: what is the ControlSource of the totals field?
Probably "=sum([somefield])
Even though it's not elegant, you may want to replace with a DSum
function call.

Can you reproduce the behavior with (a small modification of) one of
the sample applications?

You're not in an ADP by any chance? If yes, this hotfix may apply:
http://support.microsoft.com/kb/936519

-Tom.



>Hello Everyone,
>
>I'm having some very weird behavior on a couple of Access forms. (Not
>all forms, just some of them).
>
>The forms have been working for years, under Access XP/2003 etc, and
>last week upgraded from Windows XP/Office 2003 to Vista x64/Office
>2007.
>
>Under Access 2007, a couple of forms are now taking 60 seconds to
>calculate a total field in a subfoirm. (ie, Invoice Totals). Under
>Access 2003, this was perhaps under 1 second, basically instant. I've
>compacted the database, I've compared properties with forms/controls
>etc that work Ok. I can't work it out!
>
>I Initially thought there must be some change in 2007's form
>properies, as I thought the total was just not calculating at all.
>(ie, put msgbox(InvoiceTotal) in the form's OnCurrent Event, which
>gave BLANK/Null display).
>
>Ok.... When I updated to Vista/Access 2007, Some of the terminals
>remained (and still do) on Access 2003. These terminals display the
>Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
>as long to display the form Totals. Basically, the XP/2003
>Terminals give the totals instantly like they should.
>
>
>I'm interested to hear from others. I've searched high and low, on
>Forums, google etc.
>
>Totally weird.
>
>
>Thanks for listing! Any similar experiences or resolutions, I'd love
>to know!
>
>
>Elias Farah.

"Best Way" to produce labels/report.

I have to print a series a labels. Each record selected may have from 1
to 10 labels to output. Being new to Access and VB I'm unsure of the
best direction to take for this. Should I use a query to build a query
table that contains a listing for each label or should I use a report
that outputs a label for each record? I believe the most desirable way
would be with a report. However, I'm really not sure of how to put in
the necessary code to break out each single record into the multiple
records needed for the labels. I spent the last 12 years programming
Pick style (Universe) databases with databasic and it isn't a big deal
there. I suspect it's the same case here but I'm lost.

Any advice or direction would be much appreciated.

BTW, I've learned a lot from just reading the forum.

Robert Martin

--
I am using the free version of SPAMfighter for private users.
It has removed 15409 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Re: "Best Way" to produce labels/report.

Well, a little searching and I found out how to do this. Allen Browne's
web site of tips and ticks had just the ticket and it works great.

Thanks!

Robert Martin

"Robert Martin" wrote in message
news:DpOdndD5IbzyW4fanZ2dnUVZ_ryqnZ2d@giganews.com:

> I have to print a series a labels. Each record selected may have from 1
> to 10 labels to output. Being new to Access and VB I'm unsure of the
> best direction to take for this. Should I use a query to build a query
> table that contains a listing for each label or should I use a report
> that outputs a label for each record? I believe the most desirable way
> would be with a report. However, I'm really not sure of how to put in
> the necessary code to break out each single record into the multiple
> records needed for the labels. I spent the last 12 years programming
> Pick style (Universe) databases with databasic and it isn't a big deal
> there. I suspect it's the same case here but I'm lost.
>
> Any advice or direction would be much appreciated.
>
> BTW, I've learned a lot from just reading the forum.
>
> Robert Martin
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 15409 spam emails to date.
> Paying users do not have this message in their emails.
> Get the free SPAMfighter here: http://www.spamfighter.com/len

--
I am using the free version of SPAMfighter for private users.
It has removed 15409 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Re: Subform Totals Very Slow Access 2007

Are you running the 2003 version with access 2007 or did you upgrade
the front end completely to the 2007 version?

In all versions, upgrades don't always work 100%. Go into your code
window and try a compile....

You might need to refactor your code as mentioned.

Are there lots of subforms and many tabs etc?

Regards,
Tom Bizannes
15 years spent with access and many more to go....
Sydney, Australia

Re: Subform Totals Very Slow Access 2007

"ARC" wrote in
news:M5KSi.9021$sm6.3496@nlpi069.nbdc.sbc.com:

> I'm having a customer with the same issue with Access 2007. Please
> post if you find an answer, and I'll do the same. The only thing
> I've found that is close on MS's site is:
>
> http://support.microsoft.com/kb/891176/en-us
>
> However, the article refers to long file names / folder names, as
> being the culprit, and converting to a standard 8.3 file name
> conversion. However, with Access 2007, and the extention: .accdb,
> I'm not sure how the extention would convert to a short filename.
>
> Andy
> wrote in message
> news:1192925696.445636.190650@i13g2000prf.googlegroups.com.. .
>> Hello Everyone,
>>
>> I'm having some very weird behavior on a couple of Access forms.
>> (Not all forms, just some of them).
>>
>> The forms have been working for years, under Access XP/2003 etc,
>> and last week upgraded from Windows XP/Office 2003 to Vista
>> x64/Office 2007.
>>
>> Under Access 2007, a couple of forms are now taking 60 seconds to
>> calculate a total field in a subfoirm. (ie, Invoice Totals).
>> Under Access 2003, this was perhaps under 1 second, basically
>> instant. I've compacted the database, I've compared properties
>> with forms/controls etc that work Ok. I can't work it out!
>>
>> I Initially thought there must be some change in 2007's form
>> properies, as I thought the total was just not calculating at
>> all. (ie, put msgbox(InvoiceTotal) in the form's OnCurrent Event,
>> which gave BLANK/Null display).
>>
>> Ok.... When I updated to Vista/Access 2007, Some of the terminals
>> remained (and still do) on Access 2003. These terminals display
>> the Subform Totals Instantly. Only the Vista/Office 2007 take
>> 100 times as long to display the form Totals. Basically, the
>> XP/2003 Terminals give the totals instantly like they should.
>>
>>
>> I'm interested to hear from others. I've searched high and low,
>> on Forums, google etc.
>>
>> Totally weird.
>>
>>
>> Thanks for listing! Any similar experiences or resolutions, I'd
>> love to know!
>>
>>
>> Elias Farah.
>>
>
Last week I had a totals query take about a minute to return an
average, using Access 2003 connecting to a sql server back end.

I found that the query was not seeing the primary key of the linked
table, which was being used in a join

Relinking the table fixed the issue. Perhaps that may help.



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Re: Subform Totals Very Slow Access 2007

I'm having a customer with the same issue with Access 2007. Please post if
you find an answer, and I'll do the same. The only thing I've found that is
close on MS's site is:

http://support.microsoft.com/kb/891176/en-us

However, the article refers to long file names / folder names, as being the
culprit, and converting to a standard 8.3 file name conversion. However,
with Access 2007, and the extention: .accdb, I'm not sure how the extention
would convert to a short filename.

Andy
wrote in message
news:1192925696.445636.190650@i13g2000prf.googlegroups.com.. .
> Hello Everyone,
>
> I'm having some very weird behavior on a couple of Access forms. (Not
> all forms, just some of them).
>
> The forms have been working for years, under Access XP/2003 etc, and
> last week upgraded from Windows XP/Office 2003 to Vista x64/Office
> 2007.
>
> Under Access 2007, a couple of forms are now taking 60 seconds to
> calculate a total field in a subfoirm. (ie, Invoice Totals). Under
> Access 2003, this was perhaps under 1 second, basically instant. I've
> compacted the database, I've compared properties with forms/controls
> etc that work Ok. I can't work it out!
>
> I Initially thought there must be some change in 2007's form
> properies, as I thought the total was just not calculating at all.
> (ie, put msgbox(InvoiceTotal) in the form's OnCurrent Event, which
> gave BLANK/Null display).
>
> Ok.... When I updated to Vista/Access 2007, Some of the terminals
> remained (and still do) on Access 2003. These terminals display the
> Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
> as long to display the form Totals. Basically, the XP/2003
> Terminals give the totals instantly like they should.
>
>
> I'm interested to hear from others. I've searched high and low, on
> Forums, google etc.
>
> Totally weird.
>
>
> Thanks for listing! Any similar experiences or resolutions, I'd love
> to know!
>
>
> Elias Farah.
>

Re: Subform Totals Very Slow Access 2007

On Oct 21, 11:19 am, "ARC" wrote:
> I'm having a customer with the same issue with Access 2007. Please post if
> you find an answer, and I'll do the same. The only thing I've found that is
> close on MS's site is:
>
> http://support.microsoft.com/kb/891176/en-us
>
> However, the article refers to long file names / folder names, as being the
> culprit, and converting to a standard 8.3 file name conversion. However,
> with Access 2007, and the extention: .accdb, I'm not sure how the extention
> would convert to a short filename.
>
> Andy wrote in message
>
> news:1192925696.445636.190650@i13g2000prf.googlegroups.com.. .
>
> > Hello Everyone,
>
> > I'm having some very weird behavior on a couple of Access forms. (Not
> > all forms, just some of them).
>
> > The forms have been working for years, under Access XP/2003 etc, and
> > last week upgraded from Windows XP/Office 2003 to Vista x64/Office
> > 2007.
>
> > Under Access 2007, a couple of forms are now taking 60 seconds to
> > calculate a total field in a subfoirm. (ie, Invoice Totals). Under
> > Access 2003, this was perhaps under 1 second, basically instant. I've
> > compacted the database, I've compared properties with forms/controls
> > etc that work Ok. I can't work it out!
>
> > I Initially thought there must be some change in 2007's form
> > properies, as I thought the total was just not calculating at all.
> > (ie, put msgbox(InvoiceTotal) in the form's OnCurrent Event, which
> > gave BLANK/Null display).
>
> > Ok.... When I updated to Vista/Access 2007, Some of the terminals
> > remained (and still do) on Access 2003. These terminals display the
> > Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
> > as long to display the form Totals. Basically, the XP/2003
> > Terminals give the totals instantly like they should.
>
> > I'm interested to hear from others. I've searched high and low, on
> > Forums, google etc.
>
> > Totally weird.
>
> > Thanks for listing! Any similar experiences or resolutions, I'd love
> > to know!
>
> > Elias Farah.

Last week I had a totals query take about a minute to return an
average, using Access 2003 connecting to a sql server back end.

I found that the query was not seeing the primary key of the linked
table, which was being used in a join

Relinking the table fixed the issue. Perhaps that may help.