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. Thanks.

Interesting question. I'm not sure there is such a thing as SQL that will
insert a binary object into an OleDB field unless the source of the binary data
is another table with an OleDB field. If there is I have never seen an example.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Query SQL database
    ... Is this an SQL query in Enterprise ... Manager or Query Analyzer, in VB or VBScript, linked servers? ... Recordset object, for example, to return a recordset that meets the ... This is an SQL server database on server ...
    (microsoft.public.windows.server.scripting)
  • Re: Get SQL Server version of each instance installed
    ... There must be an SQL query (when you connect to the default ... The problem is that I don't know how many instances each server is ... ' Enumerate account balances. ...
    (microsoft.public.windows.server.scripting)
  • Re: Out of Office assistant automation using WebDAV
    ... > Hi Lee, ... > I fired a WebDAV SEARCH request with following SQL QUERY ... the Server returns a 400 Bad Request error. ...
    (microsoft.public.exchange.development)
  • Re: Which group for SQL builder?
    ... I want to find a freeware/shareware web tool to build an SQL query to interrogate a mysql database on the server. ...
    (comp.lang.php)
  • mysql
    ... clear me that any sql query can be done from out side? ... >I used the server publishing rule to open that server to ...
    (microsoft.public.isa)