Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-03-2019, 10:54 AM   #1
Thales750
Formerly Jsanders
 
Join Date: Dec 2007
Location: Galveston, Texas
Posts: 1,671
Thanks: 54
Thanked 28 Times in 28 Posts
Thales750 is on a distinguished road
Taking Out the Trash

Well, where to begin, no, I mean really. Where to begin?

Bloat, bloat and more bloat.

I'm guesstimating there are about thirty percent extra components, in a database with over a thousand major objects. This system was built by importing, and developing, forms, queries, tables and modules, over a long period of time.

How would you go about reducing them to as close to minimum as possible. Some of the code pieces were written by Allen Brown in the late 90s early 20s. Some of that is still running.

Are there any short cuts or best practices?

__________________
Aboard Oceans Eleven on Offatts Bayou
inveniemus viam aut faciemus
Thales750 is offline   Reply With Quote
Old 10-03-2019, 10:57 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,965
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Taking Out the Trash

Hmm, not sure there is a shortcut. You could maybe start out using the dependency checker, but it doesn't check all objects.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 10-03-2019, 11:11 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,336
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Taking Out the Trash

just some basic suggestions. And assumes db has been kept in a reasonable state.

For tables, and assuming you use relationships, check if there are tables in msysobjects that are not in msysrelationships. Any that aren't are potential targets for deletion.

for forms and reports scan through your code for docmd.openform/report if you don't find the form or report they also are potential targets for deletion. Take care re subforms/reports

Queries are more problematic and I don't have any simple suggestions right now.

Having identified the potential tables/forms/reports for deletion, turn off autocorrect if on, then rename those potential items with a zz prefix.

If you subsequently find something falls over, you can rename it back again. Otherwise after a few months, delete them. Alternatively move them to a db archive and bring back if required.

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 10-03-2019, 03:16 PM   #4
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,664
Thanks: 100
Thanked 1,501 Times in 1,416 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Taking Out the Trash

Get the V-tools plugin, use the Total Deep Search and enter the name of an object. It will find everywhere that it is mentioned in the entire project.

Compact and repair regularly as stuff is removed.
Galaxiom is offline   Reply With Quote
Old 10-03-2019, 03:19 PM   #5
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,664
Thanks: 100
Thanked 1,501 Times in 1,416 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Taking Out the Trash

Quote:
Originally Posted by CJ_London View Post
Having identified the potential tables/forms/reports for deletion, turn off autocorrect if on, then rename those potential items with a zz prefix.
Just posting to re-emphasise the importance of turning off NameAutoCorrect first in case the OP misses this detail
Galaxiom is offline   Reply With Quote
Old 10-05-2019, 09:47 AM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,272
Thanks: 15
Thanked 1,595 Times in 1,515 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Taking Out the Trash

I would start with Total Access Analyzer by www.FMSINC. It isn't free. It isn't "cheap" but it will save you a lot of time and so will pay for itself. It has tons of reports that help you to connect the dots and to find objects which are not being used.

In my databases, I always turn off NameAutoCorrect and leave it off unless I want it to do its thing. It MUST be off to make my following suggestion work.

When I find objects I think are not used, rather than deleting them, I rename them to zzzoriginalname to push them to the end of the list and I leave them for a month or two. The reason for having NameAutoCorrect off is because it will be "helpful" and reconnect any reference to the zzz name which isn't what you want at all. You want things to break so you can actually identify if this object is used in some obscure way.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 10-18-2019, 06:38 AM   #7
Thales750
Formerly Jsanders
 
Join Date: Dec 2007
Location: Galveston, Texas
Posts: 1,671
Thanks: 54
Thanked 28 Times in 28 Posts
Thales750 is on a distinguished road
Re: Taking Out the Trash

Thanks All

__________________
Aboard Oceans Eleven on Offatts Bayou
inveniemus viam aut faciemus
Thales750 is offline   Reply With Quote
Old 10-18-2019, 07:39 AM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,965
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Taking Out the Trash

Quote:
Originally Posted by Thales750 View Post
Thanks All
Good luck!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete from 2 tables with trash can gumbi17 Forms 2 10-28-2011 05:21 AM
Taking out £0.00 rows colkas Reports 11 05-12-2011 01:00 AM
Stock Taking...HOW? dave1234 General 2 08-24-2003 05:46 AM
Taking ages. Why? Mansoor Ahmad Reports 2 06-19-2003 07:03 AM
I'm Thinking about taking the VBA Course.. DaniBoy General 4 09-13-2002 05:02 AM




All times are GMT -8. The time now is 06:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World