Documenting a database

[Beeblebrox]

How can I document a database? e.g. exporting, saving, or printing the property sheets.
I'm giving the database to someone, but if they break it I need to be able to quickly scan things to see what they changed.


I will be locking it down with passwords etc., but I have to give the password to the main person.

[orange]

An interesting question. Can you provide a list that identifies the things you would want to know if you were given a database about which you knew nothing?

brief start:
-description of the business and the priority issues if any
-statement of requirements/specification
-database design information, including a data model and any changes to date
-user interface design concepts
-operations manual/info including StartUp, Backup and recovery procedures
-software usage including versions
-user manual --general guide on how to use the system/the forms/the reports...
-overview/details of the change enhancement procedure(s) and an outstanding/to do task list
-key contacts and their roles

[vicsaccess]

If you are only wanting to document properties, code etc of the actual database i usually go to the database tools tab and look for the database documenter. you can print out about anything you want to know about your database. i use it occasionally just to get all my current code printed out.

[Beeblebrox]

Thanks
that's what I needed.

An interesting question. Can you provide a list that identifies the things you would want to know if you were given a database about which you knew nothing?

brief start:
-description of the business and the priority issues if any
-statement of requirements/specification
-database design information, including a data model and any changes to date
-user interface design concepts
-operations manual/info including StartUp, Backup and recovery procedures
-software usage including versions
-user manual --general guide on how to use the system/the forms/the reports...
-overview/details of the change enhancement procedure(s) and an outstanding/to do task list
-key contacts and their roles

[orange]

You can try Google for additional ideas/approaches: here are a few
https://www.simple-talk.com/sql/data...s-why-and-how/
http://stackoverflow.com/questions/3...ent-a-database
http://www.adivo.com/best-practices-...databases.aspx

I just found this site and file(word) that could serve as a guide(attached). Probably overkill, but it has a list of things to consider.