473,545 Members | 2,041 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2007 slow when accessing data through SQL path-through

3 New Member
Hi, I'm having major performance issues in testing with Access 2007 after Access 97 applications are converted (.mdb) format. Loading of forms or reports are 2-3 times slower in Access 2007 than in Access 97. Roughly 1/4 of our applications are affected by this problem. The problem involves those retrieving data from the backend SQL 2005 through ODBC. I ran SQL profiler and the same form/reports/code run under 2007 cause the SQL stored procedures to execute 3-4 times for each call, where execution is only once under 97. All the hotfixes have been installed up to hotfix 973405 (from Oct. of last year). The bug with stored procedures executing multiple times when opening a form/report is supposed to be completely fixed with this hotfix, according to Microsoft. But, I'm still experiencing it. This is the same result I got after testing both 97 and 2007 on a same computer and running SQL profiler. Same SQL native client, same SQL 2005 backend ... Tried everything with Access 2007 (turning off name autocorrect, error checking, subform, etc. etc.) to improve performance but the bottom line is, on the very same computer, 2007 executes SP multiple times. Am I the only one experiencing this? Is this the norm with 2007? Did Microsoft fix the bug only partially? Please, please comment.
Mar 29 '10 #1
0 1317

Sign in to post your reply or Sign up for a free account.

Similar topics

9
3163
by: WalterR | last post by:
This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as it is was under OS/390 or equ. My main experience is IMS DB, which leads to my question. In IMS, there is an HDAM access method which can find a record without using an index as such. At...
7
26938
by: ddsvi78 | last post by:
I am a complete idiot when it comes to access. Now that said, I work for a computer security company and one of our customers came to us with an access problem. They had been running fine for a long time. Then about a month ago there main server that hosted all the .mdb files crashed. So they restored everything to a new server (I believe...
13
2337
by: Neo Geshel | last post by:
I have examined about 80+ different upload scripts on the 'net, both in VB and C#, and none seem to do what I need them to do. Perhaps someone here can point me somewhere that Google hasn't reached yet (I have gone all the way to page 50 on Google's results!!). Here are my requirements: • I have a DataGrid. Everything will be done from...
49
4315
by: Allen Browne | last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new article at: http://allenbrowne.com/Access2007.html Covers what's good (useful features), what's mixed (good and bad), what's gone (features removed), what's fixed (old issues solved), what's broken (new bugs), configuration, compatibility, should you buy, and...
1
8950
by: cpajoe2001 | last post by:
I am having an issue and after searching around online for a day and half now and finding others with the same problem but yet no solution to my issue I am looking for help. What i have is ServerA which is a webserver running Win2k3 with IIS6, my domain account is a local administrator on this machine. The web app I am running is trying to...
3
9601
by: Michael | last post by:
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...
4
1209
by: Susie DBA [MSFT] | last post by:
I just love this http://www.ftponline.com/channels/net/reports/vslivesf/2007/lthekeynote2/ Microsoft still thinks that SQL Server should be 'brought into Visual Studio' hasn't this been a feature that they've already sold to us-- in ever version of VS for the past decade? I just find it humorous, Microsoft Access Data Projects are the...
11
1766
by: James Alan Farrell | last post by:
Hello, I recently installed new anti-virus software and was surprised the next time I brought up IDLE, that it was accessing the internet. I dislike software accessing the internet without telling me about it, especially because of my slow dial up connection (there is no option where I live), but also because I feel it unsafe. Can anyone...
2
15595
nico5038
by: nico5038 | last post by:
Access 2007 Linkedtable manager refuses to relink tables having a field with the "Attachment" datatype. Problem: When placing a split database in another folder, the Linked table manager should be used to relink the tables. The Linkedtable manager does however refuse to relink tables having an "Attachment" datatype field. Symptoms: Open...
1
5075
by: Ted Kennedy | last post by:
I have an Access Data Project (.adp) connecting to a SQL Server 2005 DB over the internet. The project has been running in Access 2003 for a couple of years, and performance has been very good. When I convert it to Access 2007 (maintaining the 2002-2003 file format) it gets a LOT slower. It takes about 3-5 seconds just to tab to a new field....
0
7661
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7815
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7433
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7763
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5340
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4949
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3458
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3444
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
712
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.