PC Review


Reply
Thread Tools Rate Thread

Database maintenance & modification

 
 
=?Utf-8?B?UGV0ZSBSb3RoZXJ5?=
Guest
Posts: n/a
 
      10th Oct 2006
I have a database running on a network with multiple users. It has been
developed over a two year period to cater for everyone's needs and ideas. I
have not documented either the original design or the modications: as aresult
it is inreasingly difficult to make further modifications as I have to work
out how everything functions from scratch.

This is completely my own fault but I would appreciate any suggestions on
how to improve the situation.

The db has 23 tables, 44 queries, 35 forms & 25 macros. Maybe its not that
complicated but it is enough to give me headaches!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?VG9tIFdpY2tlcmF0aA==?=
Guest
Posts: n/a
 
      10th Oct 2006
Hi Pete,

CSD Tools is a good utility to use for documenting a database, and it's
free. The only requirement is that you have to admit that you are an Access
Junkie!

http://home.bendbroadband.com/conrad.../csdtools.html

Total Access Analyzer from FMS is a very good tool for documenting Access
applications. A single user license runs US $299:

http://www.fmsinc.com/products/analyzer/index.html

I use both products, and have been very happy with them.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Pete Rothery" wrote:

> I have a database running on a network with multiple users. It has been
> developed over a two year period to cater for everyone's needs and ideas. I
> have not documented either the original design or the modications: as aresult
> it is inreasingly difficult to make further modifications as I have to work
> out how everything functions from scratch.
>
> This is completely my own fault but I would appreciate any suggestions on
> how to improve the situation.
>
> The db has 23 tables, 44 queries, 35 forms & 25 macros. Maybe its not that
> complicated but it is enough to give me headaches!

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
database maintenance lmo Microsoft Outlook BCM 1 7th Aug 2008 01:32 AM
Maintenance database George Microsoft Access Database Table Design 3 10th May 2008 07:51 PM
Database maintenance & modification =?Utf-8?B?UGV0ZSBSb3RoZXJ5?= Microsoft Access 2 11th Oct 2006 12:24 AM
Database maintenance and Database Administration? angela.solorzano@ca.wunderman.com Microsoft Excel Programming 1 5th Aug 2005 02:58 AM
Re: Database Maintenance Cary Shultz [A.D. MVP] Microsoft Windows 2000 Active Directory 0 2nd Jun 2004 01:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 AM.