Kamis, 05 April 2012

Re: [MS_AccessPros] Streaming lining the size of a back end database

 

Hi Art,

put the database closer to the root -- and make the database name shorter.  get rid of all spaces in the path too.

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

________________________________
From: Art Lorenzini <dbalorenzini@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, April 5, 2012 1:50 PM
Subject: Re: [MS_AccessPros] Streaming lining the size of a back end database

The backend sits on a server and this is the path:
 
\\CRHAGP\CRHA HomBuyer\Unit Trakker Testing\CRHA Unit Manager_be.accdb
 
Is there a better way?

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Crystal <strive4peace2008@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, April 5, 2012 2:26 PM
Subject: Re: [MS_AccessPros] Streaming lining the size  of a back end database
 

  

Hi Art,

here are my top 2 performance tips based on structure:

1. link on efficient fields and build relationships with RI

2. Build additional indexes where it makes sense. Remove default that automatically makes indexes on fields containing ~ "ID, code, key, num"...

my top performance tip for a back-end

1. put the back-end in a directory with a short path

Warm Regards,
Crystal

Microsoft MVP, Access
remote training and programming

www.AccessMVP.com/strive4peace
www.YouTube.com/LearnAccessByCrystal
www.YouTube.com/LearnByCrystal

* (:  have an awesome day :) *

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, April 5, 2012 1:13 PM
Subject: RE: [MS_AccessPros] Streaming lining the size  of a back end database

Art-

Here are a couple:

1) Turn OFF Name AutoCorrect and then edit each of the backed tables and make
sure SubformDatasheet is set to [None].

2) When your app opens in the front end, open a recordset to a linked table
(doesn't matter which one) and leave it open for the duration of the app.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

--------------------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Thursday, April 05, 2012 9:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Streaming lining the size of a back end database

 
I know there is probably a lot of tips on on how to boost the performance of a
backend database but could you give me like the top 5.

Right now I am going back through and removing all the lookups I had built into
the tables and using combos on the form do the work. What else could I look at?

I know this is a wide and varied topic but any help would be great.

Thank you,

Arthur Lorenzini
Sioux Falls, SD

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

 
     

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar