How to deal with Paper Archive?

B

BJH

Hi

A friend of mine is in the process of having an Access Database developed
for their large archive of paper documents which will be scanned and
converted to 'electronic' format.

They will need to index and view these documents once digitised.

I have no knowledge of Access (I use another form of DBM)

What would be the Access approach to this task?

File formats, etc?

PDFs?

I'm interested to hear from those 'in the know'
 
A

aaron.kempf

sounds like a WONDERFUL project.

i would reccomend using something like SQL Server or MSDE for this--
even SQL Server express.

you're not technically going to STORE the documents in a db are you?

let me know when you know more requirements.. email me if you want

[email protected]
[email protected]

i would love to help you with the design for this.
 
T

Tony Toews

BJH said:
A friend of mine is in the process of having an Access Database developed
for their large archive of paper documents which will be scanned and
converted to 'electronic' format.

They will need to index and view these documents once digitised.

I have no knowledge of Access (I use another form of DBM)

What would be the Access approach to this task?
Click to expand...

You don't want to embed graphics into a table as this causes
significantly bloating of the database. Frequently about one Mb per
graphic.

For more info see the Image Handling Tips page at my website.
http:\\www.granite.ab.ca\access\imagehandling.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top