Database maintenance & modification

[Guest]

I have a database for multiple users which has been developed over a two year
period. I have not documented anything. It is getting increasingly difficult
to make modifiations. My own fault I know but I wondered if it is possible to
rebuild as several smaller databases linked by??
The db has 23 tables, 44 queries, 35 forms, 23 reports & 25 macros. It may
not be complex by some standards but it is complex enough to give me
headaches.

I would be grateful for any help or suggestions

 

[Guest]

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/conradsystems/accessjunkie/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/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Pete,

I am not an Access master but I would think that defragging your database in
this manner would cause more problems than keeping it intact. I am working
on an application that contains 120 tables, 150 queries, 155 forms, and 25
reports (sorry no macros, my main instructor convinced me to never use them).


I used a standard and verbose naming convention, except in a few instances
when I hit the save button by accident and didn't realize it until later and
didn't want to retrace my steps.

Hopefully, others will chime in on this thread. I need to here over and
over that documentating an application is the sign of a good developer.

Not such a good developer yet. LDN