A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Free for All: help me speed up my Access Database



 
 
Thread Tools Display Modes
  #1  
Old January 10th, 2007, 07:37 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
Anthony
external usenet poster
 
Posts: 176
Default Free for All: help me speed up my Access Database

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?


  #2  
Old January 10th, 2007, 07:57 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
Stefan Hoffmann
external usenet poster
 
Posts: 709
Default Free for All: help me speed up my Access Database

hi Anthony,

Anthony wrote:
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

That's outdated: Access can go Warp 4.5.


mfG
-- stefan --
  #3  
Old January 10th, 2007, 07:58 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba
ManningFan
external usenet poster
 
Posts: 157
Default Free for All: help me speed up my Access Database

Use a SQL Server backend. And index your tables properly.

Anthony wrote:
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?


  #4  
Old January 10th, 2007, 08:02 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Niniel
external usenet poster
 
Posts: 582
Default Free for All: help me speed up my Access Database

Turn it into a multi-threaded application and run it on a multi-processor
system, that should speed things up.
For true lightspeed-like speed you'll probably have to build yourself a
quantum computer.

"Anthony" wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?



  #5  
Old January 10th, 2007, 08:02 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Klatuu
external usenet poster
 
Posts: 7,074
Default Free for All: help me speed up my Access Database

That is a subject to extensive to cover in a newsgroup. There are entire
books written on the subject.
You could search through the Microsoft Knowledge Base and see what you can
find. Also, if you can get your hands on a copy of "Access 2002 Desktop
Developer's Handbook" by Litwin, Getz, and Gunderloy, Chapter 15 looks at
this from an application perspective.

--
Dave Hargis, Microsoft Access MVP


"Anthony" wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?



  #6  
Old January 10th, 2007, 08:06 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
'69 Camaro
external usenet poster
 
Posts: 1,049
Default Free for All: help me speed up my Access Database

That's outdated: Access can go Warp 4.5.

Check your dilithium crystals for surface contaminants. Mine goes Warp 8
when I put the metal to the floor.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Stefan Hoffmann" wrote in message
...
hi Anthony,

Anthony wrote:
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

That's outdated: Access can go Warp 4.5.


mfG
-- stefan --



  #7  
Old January 10th, 2007, 08:18 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
Stefan Hoffmann
external usenet poster
 
Posts: 709
Default Free for All: help me speed up my Access Database

hi Gunny,

'69 Camaro wrote:
That's outdated: Access can go Warp 4.5.

Check your dilithium crystals for surface contaminants. Mine goes Warp 8
when I put the metal to the floor.

Oh, come on, only near the sun, eh?


mfG
-- stefan --
  #8  
Old January 10th, 2007, 08:22 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
'69 Camaro
external usenet poster
 
Posts: 1,049
Default Free for All: help me speed up my Access Database

That's outdated: Access can go Warp 4.5.
Check your dilithium crystals for surface contaminants. Mine goes Warp 8
when I put the metal to the floor.

Oh, come on, only near the sun, eh?


Right. Without the gravity assist, it can only do Warp 7.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Stefan Hoffmann" wrote in message
...
hi Gunny,

'69 Camaro wrote:
That's outdated: Access can go Warp 4.5.

Check your dilithium crystals for surface contaminants. Mine goes Warp 8
when I put the metal to the floor.

Oh, come on, only near the sun, eh?


mfG
-- stefan --



  #9  
Old January 10th, 2007, 08:26 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
John Spencer
external usenet poster
 
Posts: 7,815
Default Free for All: help me speed up my Access Database

Quote from Tony Toews
The three most common performance problems in Access 2000 a
- LDB locking which a persistent recordset connection fixes
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off
(Tools: Options: General Uncheck all name AutoCorrect features)
Other reasons are
- New format of Access 2000 MDB
- Place backend MDB on the root of the network share rather than several
folders down
- Shorten the name of the backend MDB
- Miscellaneous Performance Suggestions
End quote

Check out the following URLs for a more complete discussion.

http://www.granite.ab.ca/access/performancefaq.htm

http://support.microsoft.com/?id=209126

Also
How to speed up slow queries
http://support.microsoft.com/kb/209126/en-us
Entitled: Information about query performance in an Access database

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Anthony" wrote in message
...
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?



  #10  
Old January 10th, 2007, 08:27 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Free for All: help me speed up my Access Database

I don't believe Access can take advantage of multi-threading.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Niniel" wrote in message
...
Turn it into a multi-threaded application and run it on a multi-processor
system, that should speed things up.
For true lightspeed-like speed you'll probably have to build yourself a
quantum computer.

"Anthony" wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.