 | |
2000 or 2003 app slow in Access 2007 (Vista)
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: 2000 or 2003 app slow in Access 2007 (Vista) -
01-20-2008
, 08:01 PM
|
My only unsolved puzzle is that on one machine the Windows Security Centre reports that McAffee antivirus is installed, updated and running. |
#12
| |||
| |||
|
|
Perhaps someone else can suggest something. I have not observed that. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Arno R" <arracomn_o_s_p_... (AT) planet (DOT) nl> wrote in message news:47935f78$0$25474$ba620dc5 (AT) text (DOT) nova.planet.nl... ==> New test: A new database with *only* these three forms (and some basic modules) runs snappy. When I simply import more objects (like 50 query's) from the original db the very same forms become 'muddy' (slow). Corruption ?? I can't find anything. What is happening ?? Is Access (or is it Vista ??) indexing the whole lot ?? I turn my anti-virus (Avast) software off ==> no difference. Arno R |
2007 and see if it is snapply or muddy. I think if you choose Open ->
New some template headings appear and if you click on Sample, then the
Northwind 2007 download icon is shown. FWIW, Northwind 2007 is
"snappy" for me.
But in other dbs I have had the experience of imported objects being
muddy. IIRC saving them as text, and loading them back in Access 2007
helped. With queries, maybe you can just copy and import the SQL
string?
#13
| |||
| |||
|
|
On Jan 20, 5:56 pm, "Allen Browne" <AllenBro... (AT) SeeSig (DOT) Invalid> wrote: Perhaps someone else can suggest something. I have not observed that. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Arno R" <arracomn_o_s_p_... (AT) planet (DOT) nl> wrote in message news:47935f78$0$25474$ba620dc5 (AT) text (DOT) nova.planet.nl... ==> New test: A new database with *only* these three forms (and some basic modules) runs snappy. When I simply import more objects (like 50 query's) from the original db the very same forms become 'muddy' (slow). Corruption ?? I can't find anything. What is happening ?? Is Access (or is it Vista ??) indexing the whole lot ?? I turn my anti-virus (Avast) software off ==> no difference. Arno R To see if it's the database, or Access, you could download Northwind 2007 and see if it is snapply or muddy. I think if you choose Open - New some template headings appear and if you click on Sample, then the Northwind 2007 download icon is shown. FWIW, Northwind 2007 is "snappy" for me. But in other dbs I have had the experience of imported objects being muddy. IIRC saving them as text, and loading them back in Access 2007 helped. With queries, maybe you can just copy and import the SQL string? |
Well it's the database indeed... (I allready noticed that Northwind 2007 is snappy)
For several years now I develop my apps with 'the Internet hand' showing.
The 'hand' shows when you move the mouse over a clickable control.
This 'hand' is invoked by simply setting the property 'Hyperlinksubaddress' to a space.
See: http://groups.google.nl/group/comp.d...3f55b7c7ffc50a
Btw: I see that Access 2007 has a new property (cursor on ... 'hyperlinkhand' ) to do the very same...
==> Simply removing the spaces I use everywhere for the 'Hyperlinksubaddress' solves the speed-issue.
==> My app is 'snappy' as is was before ! Problem solved!
So I am glad my new laptop *is* speedy enough to run Vista and Access 2007.
Still strange though that starting with *only* 3 forms (with hyperlinksubaddress property set to a space) the app is
speedy enough, while adding some query's slows down the forms ....
I tested this again, and I can repeat it over and over again. Nevertheless: problem is solved.
New problem:
Now it seems that I need different apps for Access 2007 and earlier versions...
(When I remove all the spaces, the 'hand' wil not show when using Acc2k or Acc2003...)
Again I tried to install SP1 for Office 2007 to see if the issue is solved with SP1.
Maybe because I have an evaluation version the update fails ??
Would anyone here be willing to check the behaviour of spaces in the hyperlinksubaddress property with Access2007 SP1??
Thanks much
Arno R
#14
| |||
| |||
|
|
Again I tried to install SP1 for Office 2007 to see if the issue is solved with SP1. Maybe because I have an evaluation version the update fails ?? Would anyone here be willing to check the behaviour of spaces in the hyperlinksubaddress property with Access2007 SP1?? Thanks much Arno R |
Sorry, previous message posted from my laptop with newsaccount not properly setup ...
I still would like to know if the speed-issue I described in this thread is solved with Access 2007 SP1.
Anyone here willing to test this ??
Speed-issue:
(Access2007 and Vista).
Setting the property hyperlinksubaddress of a commandbutton to a space or to #, results in a delay of a few seconds here.
Behaviour seems to be the same with mdb or accdb format.
Thanks
Arno R
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.