By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,023 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Slow code execution in Access 2007

P: n/a
I work with a highly programmed Access
database (some 15,000 lines of VBA code, much of it automating data
entry on forms -- and believe me, it's very tight code). In Access
97,
2000, 2002, and 2003, no performance problems. However, when I open
the same database in Access 2007, it's as slow as molasses. Data
trickles onto the form instead of an immediate display in Access
2003.
This happens regardless of whether I keep the Access 2002-2003 file
format or convert it to Access 2007. I have the recommended
1 GB RAM. I'm NOT using Office 2007 Beta. No missing references.

I'm beginning to notice more threads complaining of Office 2007
performance problems. Most often they seem to be tied to VBA code
execution. One example (for Excel 2007):
http://groups.google.com/group/micro...b163f9d22c9629

Any ideas?

Feb 27 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I not experianced a code slow down. You can test your code speed, and likey
ms-access can execute about 50 million instrucions in one second.

Public Sub test4444()

Dim lngMax As Long
Dim i As Long
Dim t As Double

lngMax = 80000000

t = Timer
For i = 1 To 80000000
Next i
t = Timer - t

MsgBox "time = " & t & vbCrLf & _
"loops per second = " & lngMax / t
End Sub
Try the above. I not really noticed a code speed change. The above loops to
80 million..and most pc's today will do that in less then 2 seconds.

Is a network involved? Have you tried using a mde...does that help?
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
"Michael" <mm*******@comcast.netwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...
>I work with a highly programmed Access
database (some 15,000 lines of VBA code, much of it automating data
entry on forms -- and believe me, it's very tight code). In Access
97,
2000, 2002, and 2003, no performance problems. However, when I open
the same database in Access 2007, it's as slow as molasses. Data
trickles onto the form instead of an immediate display in Access
2003.
This happens regardless of whether I keep the Access 2002-2003 file
format or convert it to Access 2007. I have the recommended
1 GB RAM. I'm NOT using Office 2007 Beta. No missing references.

I'm beginning to notice more threads complaining of Office 2007
performance problems. Most often they seem to be tied to VBA code
execution. One example (for Excel 2007):
http://groups.google.com/group/micro...b163f9d22c9629

Any ideas?

Feb 27 '07 #2

P: n/a
If it's not code execution, what else could be slowing down the
display of data on the form? I'm well aware of things that commonly
slow down form display performance -- domain aggregate expressions in
the record source, the number of subforms, etc. But the only
difference here is the version of Access I use to open the database. I
won't attempt to test this on a network until it performs adequately
on a workstation.

By the way, I'm testing on a workstation that has never had Office
installed on it before, so there should be no complications from
multiple versions of Office.

On Feb 27, 12:10 pm, "Albert D. Kallal"
<PleaseNOOOsPAMmkal...@msn.comwrote:
I not experianced a code slow down. You can test your code speed, and likey
ms-access can execute about 50 million instrucions in one second.

Public Sub test4444()

Dim lngMax As Long
Dim i As Long
Dim t As Double

lngMax = 80000000

t = Timer
For i = 1 To 80000000
Next i
t = Timer - t

MsgBox "time = " & t & vbCrLf & _
"loops per second = " & lngMax / t

End Sub

Try the above. I not really noticed a code speed change. The above loops to
80 million..and most pc's today will do that in less then 2 seconds.

Is a network involved? Have you tried using a mde...does that help?

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKal...@msn.com

Feb 27 '07 #3

P: n/a
"Michael" <mm*******@comcast.netwrote in message
news:11**********************@j27g2000cwj.googlegr oups.com...
If it's not code execution, what else could be slowing down the
display of data on the form?
Well, it could be a number of things..including a slow down in data access,
or even the user interface is running slow for some reason.

I was just pointing out that code speed seems to be ok in my tests.

I not done enough testing in terms of other things (such as form load etc).
(and, my testing is being done on virtual pc right now).

So, these problems are not likely VBA code speed, but other issues.

I just plain don't have the experience yet to nail down what the issues are
as of yet...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Feb 27 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.