469,920 Members | 2,285 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,920 developers. It's quick & easy.

storing a scanned document...

RAB
I want to scan documents and then store them in an Access database.
What file type would I want to scan the document as? Would I want to
store the document file in the database or a path to the scanned
document file?

Thanks,
RABMissouri

Nov 25 '05 #1
1 3122

"RAB" <ra*********@yahoo.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
I want to scan documents and then store them in an Access database.
What file type would I want to scan the document as? Would I want to
store the document file in the database or a path to the scanned
document file?

Thanks,
RABMissouri


Personally, I've had much better results storing paths to documents than the
documents themselves. It improves performance, minimizes bloat, stores an
almost unlimited number of files and there is no limit to the document types
you can store. pdf is probably the most universally readable - almost every
system has the Acrobat Reader. jpegs are little bit smaller.
This is the filter that I set up for the Common Dialog (don't use the OCX
control) for users to add files.

' Set up the Common Dialog Filter
cdl.Filter = "All Files (*.*)|*.*" & _
"|Word Documents (*.doc)|*.doc" & _
"|Acrobat Files (*.pdf)|*.pdf" & _
"|Image Files (*.jpg, *.tif)|*.jpg;*.tif;*.jpeg" & _
"|Text Files (*.txt)|*.txt" & _
"|Excel Files (*.xls)|*.xls" & _
"|Rich Text Files (*.rtf)|*.rtf"

HTH,
Randy

Nov 25 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.