[AccessD] Keeping your db in tiptop shape

I agree with this one.  However my idea of verifying is to run audits on the tables first and verify that the data is what you expect.  Once you have done this, audit the reports/queries etc.  I try to do this once a year or so.

Sometimes I just open up some of the tables and check that everything looks like it should.  That is one advantage to having a neat, tidy and relational database.  It is much easier to audit.

just some thoughts.
regards
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, 15 April 2009 5:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Keeping your db in tiptop shape

> B. Verify your database on a regular basis.

====Jim, that's a good list, but what's this one? 

Susan H. 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.