I have a very busy input form that has about 6 graphical buttons and 6
embedded subforms.
The database backend is located on a local network; the front ends
will be on each user's C:\ drive.
It is taking a long, long time for this to load: I did go in and
reindex the tables, which speeded things up tremendously.
Is there anything else I can do to optimize performance? As of now,
in testing, when 2 users try to hit the input form at the same time,
Access dies for one of them.
Thanks!
amy
=== 18 1374
Comments in-line...
On 16 Jul 2004 13:56:14 -0700, am*******@verizon.net (amywolfie)
wrote: I have a very busy input form that has about 6 graphical buttons and 6 embedded subforms.
What kind of graphics? Some types load faster than others. (I have
found that BMPs load the fastest.
If you can load (set) the subforms RecordSource just as you need them.
Have them empty when the form is opened. The database backend is located on a local network; the front ends will be on each user's C:\ drive.
What do you mean by *will* be on the local drive. Are they sharing an
E now? It is taking a long, long time for this to load: I did go in and reindex the tables, which speeded things up tremendously.
Is there anything else I can do to optimize performance? As of now, in testing, when 2 users try to hit the input form at the same time, Access dies for one of them.
Thanks!
amy ===
In addition to Jim's comments, you will find a lot of optimizing information
at this link. http://www.granite.ab.ca/access/performancefaq.htm
--
Wayne Morgan
MS Access MVP
"Jim Allensworth" <ji****@datacentricsolutions.com> wrote in message
news:40****************@news.west.earthlink.net... Comments in-line...
On 16 Jul 2004 13:56:14 -0700, am*******@verizon.net (amywolfie) wrote:
I have a very busy input form that has about 6 graphical buttons and 6 embedded subforms. What kind of graphics? Some types load faster than others. (I have found that BMPs load the fastest.
If you can load (set) the subforms RecordSource just as you need them. Have them empty when the form is opened.
The database backend is located on a local network; the front ends will be on each user's C:\ drive.
What do you mean by *will* be on the local drive. Are they sharing an E now?
It is taking a long, long time for this to load: I did go in and reindex the tables, which speeded things up tremendously.
Is there anything else I can do to optimize performance? As of now, in testing, when 2 users try to hit the input form at the same time, Access dies for one of them.
Thanks!
amy ===
Ah, yes Tony's FAQ.
It has been a while since I have been there - a lot of new stuff.
Excellent resource.
- Jim
On Fri, 16 Jul 2004 22:18:35 GMT, "Wayne Morgan"
<co***************************@hotmail.com> wrote: In addition to Jim's comments, you will find a lot of optimizing information at this link.
http://www.granite.ab.ca/access/performancefaq.htm
-- Wayne Morgan MS Access MVP
"Jim Allensworth" <ji****@datacentricsolutions.com> wrote in message
news:40****************@news.west.earthlink.net... Ah, yes Tony's FAQ.
It has been a while since I have been there - a lot of new stuff.
Excellent resource.
All junk all the time, actually.
"Jim Allensworth" <ji****@datacentricsolutions.com> wrote: Ah, yes Tony's FAQ.
It has been a while since I have been there - a lot of new stuff.
Excellent resource.
Thanks for the kind comments. Makes the effort worthwhile.
I will soon be putting up a blog with an RSS showing any updates I make to the site
so as to help folks keep up with things.
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
"XMVP" <ac***********@hotmail.com> wrote All junk all the time, actually.
We already knew your motto, Don -- you didn't have to post it again.
In article <tV*****************@nwrddc03.gnilink.net>, bo*****@localhost.not
says... "XMVP" <ac***********@hotmail.com> wrote
All junk all the time, actually.
We already knew your motto, Don -- you didn't have to post it again.
"Larry,"
I have copied this spam post and sent it to ab***@verizon.net. We
won't tolerate your abuse around here. Let's hope they cancel your account so
that you won't be able to harass people around here any longer.
Paul
"Dr. Paul Bremmer, PhD" <Pa*********@harvard.edu> wrote in message
news:N%*******************@weber.videotron.net... In article <tV*****************@nwrddc03.gnilink.net>,
bo*****@localhost.not says... "XMVP" <ac***********@hotmail.com> wrote
All junk all the time, actually. We already knew your motto, Don -- you didn't have to post it again.
"Larry,"
I have copied this spam post and sent it to ab***@verizon.net. We won't tolerate your abuse around here. Let's hope they cancel your
account so that you won't be able to harass people around here any longer.
And what about your impersonation? Pa*********@harvard.edu , posted from a
videotron.ca account configured so that the name that appears in the
newsgroup is Mike Cowlishaw. Such stealth!
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:da***********@news04.bloor.is.net.cable.roger s.com... "Dr. Paul Bremmer, PhD" <Pa*********@harvard.edu> wrote in message news:N%*******************@weber.videotron.net... In article <tV*****************@nwrddc03.gnilink.net>, bo*****@localhost.not says... "XMVP" <ac***********@hotmail.com> wrote
> All junk all the time, actually.
We already knew your motto, Don -- you didn't have to post it again.
"Larry,"
I have copied this spam post and sent it to ab***@verizon.net. We won't tolerate your abuse around here. Let's hope they cancel your account so that you won't be able to harass people around here any longer.
And what about your impersonation? Pa*********@harvard.edu , posted from a videotron.ca account configured so that the name that appears in the newsgroup is Mike Cowlishaw. Such stealth!
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
You should talk. What about "My Silicon Tits 8785" and "Asian Teen Bondage
4552" that you cross posted to this group? Everytime I visit those sites I
get a personal welcome message from somebody called Steel Doug. You're not
kidding anybody.
Bip Bam
"Bip Bam" <Bi****@ThankYouMam.net> wrote You should talk. . . . You're not kidding anybody.
Hey, Don, better ease off -- whatever you're using is burning your brain.
It's _you_ that's not fooling anybody.
Oh, and that'd be "WhamBam" not "BipBam" if you could get your quotes right.
"Larry Linson" <bo*****@localhost.not> wrote in message
news:os*******************@nwrddc03.gnilink.net... "Bip Bam" <Bi****@ThankYouMam.net> wrote
> You should talk. . . . You're not > kidding anybody. Hey, Don, better ease off -- whatever you're using is burning your brain. It's _you_ that's not fooling anybody.
Oh, and that'd be "WhamBam" not "BipBam" if you could get your quotes
right.
yo fool that'd be bip bam by clyde mcphatter and the drifters 1954 on
atlantic.
***
bip bam
thank ya mam
kisses taste like candy jam
you can see what a fool i am
when your lips meet mine
bip bam
***
so shut yo mouth fool
Don, a racist like yourself using dialect could get into real trouble with
the people who know you are demeaning them by doing so. Better keep a look
over your shoulder next time they haul you in.
who yall calling a racist you honky bitch? you dont no nothing bout black
folks or black music so shut up bitch.
"R&B Master" <RB******@Shwoogie.net> wrote in message
news:BN******************@cyclops.nntpserver.com.. . who yall calling a racist you honky bitch? you dont no nothing bout black folks or black music so shut up bitch.
R&B Master-- Don't let Larry bother you. He's been institutionalized for
years and he's not supposed to be posting in this newsgroup. He's got this
bogeyman complex where he's terrified of people he doesn't know or people
who're smarter than him. He's probably terrified of black people too for
all I know. Anyway thanks for straightening out that bip bam saying. I
always wondered where it came from. And BTW Larry ain't no bitch! That
would be David. Hahaha. Good one R&B Master!
Yours,
XMVP
"XMVP" <ac***********@hotmail.com> wrote in message
news:wa********************@vnet-inc.com... R&B Master-- Don't let Larry bother you. He's been institutionalized for years and he's not supposed to be posting in this newsgroup. He's got
this bogeyman complex where he's terrified of people who're smarter than him.
Fortunately, he doesn't encounter them too often.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:YS*********************@twister01.bloor.is.ne t.cable.rogers.com... "XMVP" <ac***********@hotmail.com> wrote in message news:wa********************@vnet-inc.com... R&B Master-- Don't let Larry bother you. He's been institutionalized
for years and he's not supposed to be posting in this newsgroup. He's got this bogeyman complex where he's terrified of people who're smarter than him.
Fortunately, he doesn't encounter them too often.
-- Doug Steele, Microsoft Access MVP
ORIGINAL POST:
He's got this bogeyman complex where he's terrified of people he doesn't
know or people who're smarter than him.
(Doug is a typical MVP--always getting things wrong or leaving out something
important. Newbies be advised.)
"XMVP" <ac***********@hotmail.com> wrote (Doug is a typical MVP--
Yep. Typical. Smart and helpful.
And he could do dialect a lot better than you can, Don. But, unlike you, he
doesn't have some inner need to offend anyone by doing so.
"Larry Linson" <bo*****@localhost.not> wrote in message
news:Mp******************@nwrddc01.gnilink.net... "XMVP" <ac***********@hotmail.com> wrote
> (Doug is a typical MVP-- Yep. Typical. Smart and helpful.
And he could do dialect a lot better than you can, Don. But, unlike you,
he doesn't have some inner need to offend anyone by doing so.
ORIGINAL POST:
(Doug is a typical MVP--always getting things wrong or leaving out something
important. Newbies be advised.)
(And Tony AKA "Larry Linson" (bogus email) is a typical MVP--anonymous and
clueless. Newbies be advised.) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: A Future Computer Scientist |
last post by:
A question: Is it really important to think about optimizing the native code
or optimizing it for P Code? Or does the code you write make a difference?
|
by: Ian Richardson |
last post by:
I'm writing a large Javascript application (uncompressed source around
400K) which is doing almost all the initialisation it needs to in a
just-in-time manner. However, I have included an option...
|
by: J. Campbell |
last post by:
From reading this forum, it is my understanding that C++ doesn't
require the compiler to keep code that does not manifest itself in any
way to the user. For example, in the following:
{
for(int...
|
by: Bob |
last post by:
Can anyone point me to a place where I can obtain the Microsoft C/C++
Optimizing Compiler Version 7.00. It was distributed about 10 years
ago on floppy diskettes.
I had a valid license but...
|
by: PWalker |
last post by:
Hi, I have written code that I would like to optimize. I need to push it to
the limit interms of speed as the accuracy of results are proportional to
runtime.
First off, would anyone know any...
| |
by: Brian |
last post by:
In particular, this question goes out to the Microsoft C++ development
team. Back in June, Ronald Laeremans posted the following message. Has
the optimizing compiler been included with the...
|
by: Flashman |
last post by:
A little confusing with setting up optimizing options with 2003 .NET.
Under the Optimization Tab. if you set to /O1 or /O2 is the program ignoring
the settings for Inline Function expansion,...
|
by: Nick Gilbert |
last post by:
Hi,
I have to send an array of prices for a list of products over XML.
Currently my XML data looks like this:
<ArrayOfProd>
<Prod Code="productcode001">
<Prices>
<P F="2005-01-01"...
|
by: Richard G. Riley |
last post by:
Without resorting to asm chunks I'm working on a few small routines
which manipulate bitmasks. I'm looking for any guidance on writing C
in a manner which tilts the compilers hand in, if possible,...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
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,...
|
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...
|
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...
|
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...
|
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...
|
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 ...
| |
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...
| |