Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old December 28th, 2006, 02:12 PM
Registered User
 
Join Date: Dec 2006
Location: Chicago, IL, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Scanning documents and inserting them into Access

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
  #2 (permalink)  
Old December 28th, 2006, 03:26 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
  #3 (permalink)  
Old December 28th, 2006, 08:14 PM
Registered User
 
Join Date: Dec 2006
Location: Chicago, IL, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #4 (permalink)  
Old January 3rd, 2007, 09:32 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Excel pivot chart into Word documents jfejsa Word VBA 1 January 23rd, 2006 09:16 PM
Inserting Word Documents into Access showie Access VBA 4 December 14th, 2005 02:02 PM
Access and embedding Password Protected Documents dkb Access 4 January 16th, 2004 09:11 AM
"Access is denied" error for opening documents kaz VS.NET 2002/2003 1 January 5th, 2004 03:53 PM
Inserting forms fields into Access tsparker Classic ASP Databases 1 October 9th, 2003 03:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.