Re: How do you store .JPG in ACCESS using VB.NET



Yeah I just get bounced around.

I thought if I could find a solution hear in VBA land I could convert to .NET

Which is the way it it heading.

"'69 Camaro" wrote:

> Hi.
>
> > I have to do this in VB.NET.
>
> You've mistakenly posted your question in the Microsoft Access (the database
> application that's part of MS Office Professional) newsgroup. Access uses
> VBA, Jet SQL or any SQL dialect of the database server the front end is
> connected to via a SQL Pass-through query. No other programming languages
> are currently supported.
>
> Please post your question in a more appropriate newsgroup.
>
> HTH.
>
> Gunny
>
>
> "ZAK" <ZAK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:76E4EF27-BFCE-413C-84FF-9D9276DF4CCC@xxxxxxxxxxxxxxxx
> >I have written a program to store images. But it stores them as long which
> > does not allow them to be automatically rendered on a form or a report.
> >
> > I know they will bloat as they have to be de-compressed and stored in DMP
> > EMF format. Storing them in a database is a no. no but it is easier for
> > maintenance and security for what I am doing.
> >
> > I have to do this in VB.NET. The current program is using a data set and
> > adding the image raw.
> >
> > The actual requirement is store ID photo's in a single database to allow
> > access and browsing by HTML on PDA'S and by a local smart client for PC's
> >
> > I have a whole set of photo's to add that are in JPG format, the program
> > zips through them fast enough but they can't be rendered. If I add them
> > manually using ACCESS it works a dream, but I don't want to add them
> > manually,.
> >
> >
> > I want to provide the solution initially in ACCESS before proposing to do
> > it
> > properly in SQL server. It just allows me to knock up some simple forms
> > and
> > reports quicker.
> >
>
>
>
.



Relevant Pages

  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)
  • Re: Storing docs in database vs storing in file system
    ... > the file system and simply keeping a pointer to each file in the database. ... I personally found the storage in sql method ... the files when they were stored in the directory structure. ... directory structure to store all the files. ...
    (microsoft.public.sqlserver.programming)
  • Re: Sharepoint Installation MSDE Location Question
    ... I want to host the SQL Server and WSS on the ... and I want to store the SQL database on a storage array ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Simple transaction question ????
    ... in SQL data base through store procedure or function but then sounds more ... 1- I am not used to the SQL syntax in SQL server side, ... 2- Before storing those data in other database table, ... if you have to manage transaction that spawns a single database then ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Involved query / possible over Access assistance.
    ... Also, Standard SQL doesn't include a bit operator, but most SQL products ... read some database design books or articles on the WEB for info on ... However, I want to store ... > I want to then do a query for a given week. ...
    (microsoft.public.access.queries)

Quantcast