Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread DBISAM for File Transfer
Thu, Nov 1 2007 6:46 AMPermanent Link

Tony Pomfrett
My client needs to automatically transfer a MS Access database file (5-10MB) every day from a field location to their head office. They already have a DBISAM server running at Head Office. I've wriiten a test app which posts the file to a blob field in a new record every day - this means they
also have daily offsite archiving. It takes 5-10 minutes to post the record to the server. This is probably not what DBISAM was designed for but it works fine. Is anybody aware of any traps that might arise in operation?

TIA, Tony.
Thu, Nov 1 2007 4:34 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Tony,

<< My client needs to automatically transfer a MS Access database file
(5-10MB) every day from a field location to their head office. They already
have a DBISAM server running at Head Office. I've wriiten a test app which
posts the file to a blob field in a new record every day - this means they
also have daily offsite archiving. It takes 5-10 minutes to post the record
to the server. This is probably not what DBISAM was designed for but it
works fine. Is anybody aware of any traps that might arise in operation? >>

As long as the size of the file doesn't get too large - 50 megs or more,
then you should be fine.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Nov 2 2007 5:19 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tony


One important point - alter the blob block size to something sensible.

Roy Lambert
Sat, Nov 3 2007 5:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< One important point - alter the blob block size to something sensible. >>

Good point.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image