How to deal with Paper Archive?

[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'

 

[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

(e-mail address removed)
(e-mail address removed)

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

 

[Tony Toews]

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?

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