|
|
I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
mortally slow. Don't know if it's anything I've done. They used to run
quickly, but now I have to wait several minutes for a single form to even
open. What's up with this crap. Will I have to give up using forms altogether?
|
|
On Wed, 31 Dec 2008 10:51:01 -0800, Ray S. <RayS[ at ]discussions.microsoft.com>
wrote:
[Quoted Text] >I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
>mortally slow. Don't know if it's anything I've done. They used to run
>quickly, but now I have to wait several minutes for a single form to even
>open. What's up with this crap. Will I have to give up using forms altogether?
Check some of the suggestions at
http://www.granite.ab.ca/access/performancefaq.htm
In particular, add a constantly-open connection to your backend; make sure the
forms don't return any more records than needed; if you have "heavy" forms
(with multiple subforms), try to set the subforms' recordsources only when
they are needed.
--
John W. Vinson [MVP]
|
|
All forms, or in one database only? Is anything else slow (retrieveing a
file from the network, etc.)? Is it a split database? Did this happen
gradually? Do you have a copy from when it ran OK? Are you approaching the
2GB limit? Are your tables properly indexed? Is it only forms, or is it
tables, queries, and reports too? Is there any code when the form opens?
"Ray S." <RayS[ at ]discussions.microsoft.com> wrote in message
news:293E2CE8-3279-449E-98C9-FE893B1F3EC3[ at ]microsoft.com...
[Quoted Text] > I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
> mortally slow. Don't know if it's anything I've done. They used to run
> quickly, but now I have to wait several minutes for a single form to even
> open. What's up with this crap. Will I have to give up using forms
> altogether?
|
|
Basically, all forms except the simplest...no problem retrieving files from
network...not split...what is the 2GB limit?...I'm talking databases about
30,000KB in size.
"BruceM" wrote:
[Quoted Text] > All forms, or in one database only? Is anything else slow (retrieveing a
> file from the network, etc.)? Is it a split database? Did this happen
> gradually? Do you have a copy from when it ran OK? Are you approaching the
> 2GB limit? Are your tables properly indexed? Is it only forms, or is it
> tables, queries, and reports too? Is there any code when the form opens?
>
>
> "Ray S." <RayS[ at ]discussions.microsoft.com> wrote in message
> news:293E2CE8-3279-449E-98C9-FE893B1F3EC3[ at ]microsoft.com...
> > I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
> > mortally slow. Don't know if it's anything I've done. They used to run
> > quickly, but now I have to wait several minutes for a single form to even
> > open. What's up with this crap. Will I have to give up using forms
> > altogether?
>
>
|
|
I read all the stuff following your link. I checked my version of msjet and
updated to latest version...I'm not using a backend...frankly, some of the
suggestions just seem to lead one to think MSAccess has become useless.
"John W. Vinson" wrote:
[Quoted Text] > On Wed, 31 Dec 2008 10:51:01 -0800, Ray S. <RayS[ at ]discussions.microsoft.com> > wrote: > > >I'm using Access 2003 on Windows 2000 Pro machine. My forms are running > >mortally slow. Don't know if it's anything I've done. They used to run > >quickly, but now I have to wait several minutes for a single form to even > >open. What's up with this crap. Will I have to give up using forms altogether? > > Check some of the suggestions at > http://www.granite.ab.ca/access/performancefaq.htm> > In particular, add a constantly-open connection to your backend; make sure the > forms don't return any more records than needed; if you have "heavy" forms > (with multiple subforms), try to set the subforms' recordsources only when > they are needed. > -- > > John W. Vinson [MVP] > |
|
I will be turning off my computer in less than a half hour, and probably
will not return to it until after the weekend, but here are a few thoughts.
First of all, I saw your reply to John Vinson in another part of this
thread. Many people are using Access with very good results, so the problem
is not the program as such. Perhaps there is something wrong with your
particular Access installation. Have you installed all updates?
2 GB is the maximum size of an Access 2003 database file, so that's not it.
I asked if this problem affects all databases, and whether the problem came
on gradually or all at once. If you have the Northwinds database that ships
with Access, try opening that, or download one of the database templates
from the Microsoft web site. The idea is to determine whether there is a
specific file that is causing problems, or if it is any Access file.
I also asked if opening tables, queries, and reports is similarly slow, and
I asked about indexing. I can't get into indexing very much right now, but
essentially in table design view you would apply an index to fields that are
used for sorting, grouping, and searching.
I also asked if there is any code running. If so, try disabling it. Same
for any macros that run when you open the file(s).
There is information here about how to attempt recovery from database
corruption, if the problem is with a specific database:
http://allenbrowne.com/recover.html
This link contains other links to helpful information.
"Ray S." <RayS[ at ]discussions.microsoft.com> wrote in message
news:134A0FFA-FE49-4A8B-82AC-BDDCFBE17A93[ at ]microsoft.com...
[Quoted Text] > Basically, all forms except the simplest...no problem retrieving files
> from
> network...not split...what is the 2GB limit?...I'm talking databases about
> 30,000KB in size.
>
> "BruceM" wrote:
>
>> All forms, or in one database only? Is anything else slow (retrieveing a
>> file from the network, etc.)? Is it a split database? Did this happen
>> gradually? Do you have a copy from when it ran OK? Are you approaching
>> the
>> 2GB limit? Are your tables properly indexed? Is it only forms, or is it
>> tables, queries, and reports too? Is there any code when the form opens?
>>
>>
>> "Ray S." <RayS[ at ]discussions.microsoft.com> wrote in message
>> news:293E2CE8-3279-449E-98C9-FE893B1F3EC3[ at ]microsoft.com...
>> > I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
>> > mortally slow. Don't know if it's anything I've done. They used to run
>> > quickly, but now I have to wait several minutes for a single form to
>> > even
>> > open. What's up with this crap. Will I have to give up using forms
>> > altogether?
>>
>>
|
|
On Wed, 31 Dec 2008 10:51:01 -0800, Ray S. <RayS[ at ]discussions.microsoft.com>
wrote:
[Quoted Text] >I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
>mortally slow. Don't know if it's anything I've done. They used to run
>quickly, but now I have to wait several minutes for a single form to even
>open. What's up with this crap. Will I have to give up using forms altogether?
Another thing to check is your antivirus software. Some AV apps meddle with
Office applications such as Access. Try seeing if your AV is doing so and tell
it to leave your databases alone...
--
John W. Vinson [MVP]
|
|
Also, go to TOOLS > OPTIONS > GENERAL and turn off Name Auto Correct.
--
Bob Larson
Free Tutorials and Samples at http://www.btabdevelopment.com
__________________________________
"Ray S." wrote:
[Quoted Text] > Basically, all forms except the simplest...no problem retrieving files from
> network...not split...what is the 2GB limit?...I'm talking databases about
> 30,000KB in size.
>
> "BruceM" wrote:
>
> > All forms, or in one database only? Is anything else slow (retrieveing a
> > file from the network, etc.)? Is it a split database? Did this happen
> > gradually? Do you have a copy from when it ran OK? Are you approaching the
> > 2GB limit? Are your tables properly indexed? Is it only forms, or is it
> > tables, queries, and reports too? Is there any code when the form opens?
> >
> >
> > "Ray S." <RayS[ at ]discussions.microsoft.com> wrote in message
> > news:293E2CE8-3279-449E-98C9-FE893B1F3EC3[ at ]microsoft.com...
> > > I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
> > > mortally slow. Don't know if it's anything I've done. They used to run
> > > quickly, but now I have to wait several minutes for a single form to even
> > > open. What's up with this crap. Will I have to give up using forms
> > > altogether?
> >
> >
|
|
Ray S. <RayS[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >I read all the stuff following your link. I checked my version of msjet and
>updated to latest version...
Hmm, that's interesting because msjet40.dll is updated by Windows
Update as it is part of the OS.
>I'm not using a backend...
You should consider splitting.
>frankly, some of the
>suggestions just seem to lead one to think MSAccess has become useless.
The first suggestion is the most important one. The others are
typically significantly rarer but have been added as I've come across
the postings in the newsgroups.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
|
|
John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> wrote:
[Quoted Text] >>I'm using Access 2003 on Windows 2000 Pro machine. My forms are running
>>mortally slow. Don't know if it's anything I've done. They used to run
>>quickly, but now I have to wait several minutes for a single form to even
>>open. What's up with this crap. Will I have to give up using forms altogether?
>
>Another thing to check is your antivirus software. Some AV apps meddle with
>Office applications such as Access. Try seeing if your AV is doing so and tell
>it to leave your databases alone...
To be a bit more specific than meddling they do antivirus scanning of
the MDB/MDE extension when they shouldn't be.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
|
|
=?Utf-8?B?UmF5IFMu?= <RayS[ at ]discussions.microsoft.com> wrote in
news:4A23B9F0-3C16-42E8-ACC6-41DD6815DCA8[ at ]microsoft.com:
[Quoted Text] > I read all the stuff following your link. I checked my version of
> msjet and updated to latest version...I'm not using a
> backend...frankly, some of the suggestions just seem to lead one
> to think MSAccess has become useless.
Then why don't you just stop using Access, then?
Access apps don't run slowly unless you're doing something wrong.
There are a host of ways to do things wrong. Most experienced
developers long ago learned best practices. If you don't want to
spend the time learning how to develop in Access properly, then get
the hell out of Dodge now -- no one here is going to be interested
in hearing any whining about how terrible Access is, anymore than a
group of carpenters will have any patience for one of their members
complaining about his hammer.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|
|
"Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> wrote in
news:3q5ol4l7pvqv7kpl85185cberk7n6h791e[ at ]4ax.com:
[Quoted Text] > John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> wrote:
>
>>>I'm using Access 2003 on Windows 2000 Pro machine. My forms are
>>>running mortally slow. Don't know if it's anything I've done.
>>>They used to run quickly, but now I have to wait several minutes
>>>for a single form to even open. What's up with this crap. Will I
>>>have to give up using forms altogether?
>>
>>Another thing to check is your antivirus software. Some AV apps
>>meddle with Office applications such as Access. Try seeing if your
>>AV is doing so and tell it to leave your databases alone...
>
> To be a bit more specific than meddling they do antivirus scanning
> of the MDB/MDE extension when they shouldn't be.
....because there's no such thing as an MDB/MDE virus.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|
|
|