By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,226 Members | 1,166 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,226 IT Pros & Developers. It's quick & easy.

storing a scanned document...

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a

"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.