Database to store procedures

[FL]

Is there a database sample or recommendation on how to create, format and
store a simple work procedure? This will be used to create and store
multiple procedures that can include revision control on each record
(procedure document). Can this be done without having procedures as linked
attachments? I'd rather create and store the procedure right on the database.

 

[Klatuu]

Depends on the volume of data. Text documents can be fairly large in file
size. Remember, there is a 2GB limit to the size of an mdb file.

The ususal way to do this is to have a specific directory where documents
are stored, and a field in your table that has the path and filename to the
document. You may consider using the FollowHyperLink method to open the
documents.

 

[Pat Hartman]

If you don't need special formatting such as bold and colors, it is easy
enough to do this totally within Access. I have created several
applications that produce shop floor control documents which are essentially
procedures for manufacturing something.

You can use reports to print out the instructions. If you want rich text
formatting, you need a RTF control. Access 2007 comes with one or you can
get one from www.fmsinc.com that can be used on forms or reports.