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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|