[AccessD] Scanning into mdb

Hi Jim:

The one thing that I have learned using graphics in an Access application is
to not insert the graphic. A MDB file only has a 2 GB limit and it is
amazing how fast the file can fill up. An application, I worked on was
originally A97 and was migrated to A2K without issue. The graphic editor and
scanner were linked and I do not remember any issues around upgrading.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco
Sent: December 29, 2005 7:58 AM
To: AccessD (E-mail)
Subject: [AccessD] Scanning into mdb

List,

I see in the archives that some of you have implemented scanning of images
into your Access systems.  I'm being asked to add some imaging to an
existing A97 app that runs in the field on laptops and I've got some
questions.

1. Did you scan into BLOB data fields or store in graphic image format?  I'd
prefer to use BLOBs as we'll be scanning HIPAA protected personal health
information and I don't want files on the laptops that anyone can access.
If you used BLOBs how did you tell the scanner where to store the data?

2. Are BLOBs an issue in A97?  The users fear data corruption.  There will
be 1-200 medical charts scanned in per day then the data is replicated back
to our main db here.

3. We will be moving to A2K3 within the next few months and probably Win XP
(from 2000).  Will twain support in A2K3 and WinXP be an issue?  If so what
can I do in our A97 app now that will prevent issues when we upgrade the
mdb?  Are BLOBs an issue in A2K3?

This app is for data collection only and if we do store as BLOB we will
convert to graphic image for storage and retrieval here so the images would
not sit in the mdb for long.

TIA

Jim DeMarco
Director of Application Development
Hudson Health Plan


****************************************************************************
*******
"This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited.  If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message.  Thank You".
****************************************************************************
*******

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com