Hello,

Could someone please help me? I am building an intranet website for my job in HR. The only thing is that they would like to scan the documents they receive from the employees and have the ability to view them when they pull the info on the employee in question. It was suggested that the scanned documents be put into the Access database they are using. So I am trying to figure out the best way to accomplish this without inflating the database too much size wise. I'm going to use Visual Studio 2003 for creating the web pages. Any ideas, thoughts, comments are greatly appreciated! Thank you!:)

Debbie Taylor

If you are using a web site, link the documents and store them on the web server or somewhere the web server can see them. Do not store them in Access.

Alternatively, you could move to SharePoint and attach the documents to list entries instead of using records.

Did that help?

mmcdonal

Thank you! It does help. For the alternative, how would you do the SharePoint thing? SharePoint is something I know nothing about, but I do know that CPS uses it.

Debbie Taylor

SharePoint is a collaboration environment, but you can use it to store documents. It uses two databases, a configuration database and a content database. You can create a Document Library to keep your records in by Name. You could also create a Document Library for each depertment or each employee (that would get too cumbersome).

It is easy to install and configure, and then creating web sites is all point and click. There is no coding for the most part (unless you really want to get into it.) You can't o relational datbases, however, just flat tables for the most part. But a list of employees with document locations would work if there was more than one doc per employee.



mmcdonal