So I developed this nice small database. 7.5 Mb is not exactly big. On Access 2003 it runs like a breeze. But on Access 2007 it seems to "run" slow motion. I decompiled and compiled it back on Access 2007. It continues irritatingly slow. Oh, and the size grew to 9.3 Mb. So I copied all content in a brand new 2007 database, compiled it and then ran: ms access /decompile. Compiled it again but it's still about 1.5 Mb bigger than when doing the same proceedure on MS Access 2003. Anything I can do about this?
Eric
5  13800 
So I developed this nice small database. 7.5 Mb is not exactly big. On Access 2003 it runs like a breeze. But on Access 2007 it seems to "run" slow motion. I decompiled and compiled it back on Access 2007. It continues irritatingly slow. Oh, and the size grew to 9.3 Mb. So I copied all content in a brand new 2007 database, compiled it and then ran: ms access /decompile. Compiled it again but it's still about 1.5 Mb bigger than when doing the same proceedure on MS Access 2003. Anything I can do about this?
Eric
Hi Eric,
You need to review the link and see if there are any items on the list that apply to you and correct. Hopefully, in the review process something will stand out as an incompatibility or bug that you can fix and be up to speed. http://allenbrowne.com/Access2007.html .
Hi Eric,
You need to review the link and see if there are any items on the list that apply to you and correct. Hopefully, in the review process something will stand out as an incompatibility or bug that you can fix and be up to speed.
http://allenbrowne.com/Access2007.html .
Thanks puppydogbuddy,
I read the content of the link. Nothing stood out that I thought, this can be it. Actually, I don't like the look and feel of Access 2007 at all. Or all Office 2007 components for that matter. It looks bloated and I hate the colors. If only it could be made to look like Office 2003.
Take care,
Eric
I think I found out the reason : "Keyboard Language" property of the field should be set to "System".
This is what I tried, and "YES" the speed is just fine!
Please spread the word, I have been chasing this for almost a "Year"now!
Good luck
zmbd 5,501
Recognized Expert Moderator Expert
To clarify Harounhdbdb comment:
In design view of a form, for each field, Harounhdbdb has appeared to have found that by leaving the default value of "System" for the Keyboard language property has helped to improve his speed.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
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 links.
It is opinion, so you may disagree, but hopefully it's an informative
summary.
|
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 of an immediate display in Access
2003.
This happens regardless of whether I keep the Access...
|
by: ARC |
last post by:
Just curious if anyone is having issues with Acc 2007 once the number of
objects and complexity increases? I have a fairly large app, with many
linked tables, 100's of forms, queries, reports, and lots of vba code. I'm
nearly finished with re-doing my app in access 2007, and just imported an
add-in program, which has added even more forms, queries and linked tables.
Every so often now, after opening many different screens, I'll...
|
by: elias.farah |
last post by:
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
|
by: cwoll |
last post by:
Hi
I need help. I have a ms access 2003 database that I would like to
upgrade to ms access 2007. The first time I opened I had to fix a few
references it wanted a DAO2535.TLB file witch I gave it, and a
utility.mda file witch I think i gave it. The instructions on
Microsoft's web sight were not very clear where to put the utility.mda
so I am not sure if I have it at the right place. The Database does
not ask for it anymore.
I have...
| | |
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.
Everything seems to work, it's just as if it is moving in molasses.
Any ideas on what could be...
|
by: Bobby |
last post by:
Hi,
The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.
I've heard that it's possible that the version of Office we are buying
may have compatability issues with Access 2003. I find this hard to
believe, but does anybody know anything about this?
Thanks
|
by: Arno R |
last post by:
Hi all,
So I bought a new laptop 10 days ago to test my apps with Vista. (home premium)
Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1)
So I take the opportunity to test some new features of Access2007 before actually 'stepping over'.
First thing that troubles me of course is 'the ribbon', but my question now is about speed.
I opened one of my Access 2000-apps in Access 2007.
Speed and...
|
by: dbdream |
last post by:
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
