Re: MS Access

Hi Gerry,

I think the best way would be to include the relative path to the picture
rather than actually embed the picture into the access database. This way
you will be able to export to any text file, adn still use all of the data.
Also, as a note, embedding 1200 pics into Access will slow it down, so
again, using text will be a better alternative.

HTH.

Awais Bokhari, Vice President
Cititech Solutions, Inc.
http://www.Cititech.net

----- Original Message -----
From: Gerry Chamberland <gchamber(at)iaw.on.ca>
To: 'HWG techniques mailing list' <hwg-techniques(at)hwg.org>
Sent: Tuesday, February 01, 2000 10:01 PM
Subject: MS Access


> Hi gang:
>
> I need an answer to a question posed to me by one of our clients.
>
> Situation:
>
> The client has an MS Access database with some 1200 items with information
> on each item in separate fields.  This was all text stuff.  They now want
to
> include pictures for each of these items.  They set out to take pictures
of
> each item and now want to create a new field in the database to place a
> picture for each item.
>
> Here are the choices they have come up with...
>
> 1. Unbound object frame/Embedded object - the sample they used to
> portray this type of control was to put a logo on an invoice report.
>
> 2. Unbound object frame/Linked object - the sample they used to portray
> this type of control was for MS Excel worksheet in a sales report.
>
> 3. Bound object frame/Embedded object - the sample they used to portray
> this type of control was to place each employee's picture in an employee
> table. (This by the way, sounds like the right one)
>
> 4. Bound object frame/Linked object - the sample they used to portray
> this type of control was to put employees resumes in an employees form
> that you can maintain using MS Word.
>
> The Issue:
>
> They would like to use this database on a regular basis in their business.
> Now they would also like this on the net.  Presently, I have a java
program
> that provides the information on the net using a flat text file which is
> delimited.  I just export the data from MS Access to a delimited text
format
> and place it on the server where the Java program grabs the stuff and
places
> it in its proper place.
>
> The Question:
>
> What would be the best way for them to proceed (include the pictures) so
> that I can receive this database and be able to save it as a flat file
which
> would also include the pictures?
>
> Any help would be appreciated.
>
>
> Gerry
> Gerry Chamberland
> http://www.milleniumstudios.com
> http://www.fallscasino.com
>
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA