RECMGMT-L Archives

Records Management

RECMGMT-L@LISTSERV.IGGURU.US
Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: records storage database
From:
"Link, Gary M." <[log in to unmask]>
Reply To:
Records Management Program <[log in to unmask]>
Date:
Wed, 27 Apr 2005 09:44:28 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (36 lines) 
Gus,

I use MicroSoft Access and it does everything you describe and more. I do data entry in the datasheet view as opposed the form view, because it is much faster. I have a "boxes" table at the box level that I use to manage the records center -- retention, location, disposition, etc. I have a "files" table that lists every file in every box, which I use for searching. And I have a "retrievals" table where I log and track retrievals for staff. And you can create just about any type of query you think of. I set up blank "files" tables on users' computers where they do the data entry for their own boxes, email it to me, and I append it to my main database (after a QA/QC check). Right now I have about 6,000 boxes and 42,000 files.

I don't write this to advertise for MicroSoft, but rather to point out that I used something that my company had already, and so incurred no cost. Perhaps you also have a ready-made solution in your organization, and so don't have to write a new database program from scratch.

Good luck,
Gary Link, CRM
Corporate Records Manager
Astorino
227 Fort Pitt Boulevard
Pittsburgh, PA  15222
412.765.1700
412.765.1711 Fax
www.astorino.com


-----Original Message-----
From: Records Management Program [mailto:[log in to unmask]]On
Behalf Of Gus Harris
Sent: Wednesday, April 27, 2005 9:29 AM
To: [log in to unmask]
Subject: records storage database


Hi folks...Gus Harris here from the Univ. of West Florida, Pensacola, FL.
I've got a question about inactive records storage database software.


CONFIDENTIALITY / PRIVACY NOTICE:  This email, and any files transmitted with it, may contain confidential and/or privileged information intended solely for the use of the individual
to whom it is addressed.  If you are not the intended recipient, you are notified that disclosing, copying, or distributing any of the contents of this information is strictly prohibited.
Please notify the sender immediately by reply email if you have received this email in error and delete this email from your system.

List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance

ATOM RSS1 RSS2