Re: Storing binary images in Access

pblecha wrote:
I need to store binary files in an Access database. Please, just skip the
discussion about creating links, and storing the images on a server; I need
to see what the SQL query would look like to store a binary in the database.

You can't do it using a query, you need to use VB - this KB article
'Reading, Storing, & Writing Binary Large Objects (BLOBs)' explains
how: <http://support.microsoft.com/kb/103257>

--
Neil Sunderland
Braunton, Devon

Please observe the Reply-To address
.

Relevant Pages

  • Re: Storing a private key
    ... Storing secrets is a hard problem. ... I have a server and client program. ... The server also uses the same public key to encrypt other files it has ...
    (microsoft.public.dotnet.security)
  • Re: Web Service State
    ... Caching is the way we have gone with this, storing each settings class using ... users store the session state. ... - Store state on the server and uniquely identify each visitor. ... We use windows authentication to authorise users to our web service, ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Global.Asax ?
    ... > I am attempting to use the Global.Asax to store my user's configuration. ... cookie is uniquely identified by its Logon ID ... > storing user's variables inside MS/SQL Server due to performance. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to store picture (*.jpg, *.bmp, *.gif) into sql database ?
    ... I'm for storing files on the file system. ... My perspective is from the simple .NET server and DB server ... If you store files in your database, the files must be streamed through ... Tampa .NET Koder wrote: ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Where to keep the data?
    ... I have not strong feeling either way regarding storing a DBC on a server ... You mention the server might go down in certain cases. ... >data on a file server to a SQL Server back end. ...
    (microsoft.public.fox.programmer.exchange)