Databases
StackOverflow2013
Postsdbo
POStore Byte[] in Access 2010
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POStore Byte[] in Access 2010
    primarykey
    data
    text
    <p>Such a simple task: <strong>How to store a Byte[] in Access 2010?</strong> (Searching the web all day long about this.)</p> <p>I have to use a "Attachment Field" in access 2010 because as far as i can see there is no other possible (varBinary, Image,..) field available.</p> <p>I tried: (ConvertImageToByte returns a Byte[])</p> <pre><code> Cmd.CommandText = "UPDATE Clubs SET Field1 = @File WHERE Name = @Name"; OleDbParameter para = new OleDbParameter("@File", OleDbType.VarBinary); para.Value = ConvertImageToByte(Logo); Cmd.ExecuteNonQuery(); </code></pre> <p>Exception: "An UPDATE or DELETE query cannot contain a multi-valued field."</p> <p>I tried:</p> <pre><code> DBEngine dbe = new DBEngine(); Database db = dbe.OpenDatabase("database.accdb", false, false, ""); String Command = "SELECT * FROM Clubs"; Recordset rs = db.OpenRecordset(Command, RecordsetTypeEnum.dbOpenDynaset, 0, LockTypeEnum.dbOptimistic); rs.MoveFirst(); rs.Edit(); Recordset2 rs2 = (Recordset2)rs.Fields["Field1"].Value; rs2.AddNew(); Field2 f2 = (Field2)rs2.Fields["FileData"]; f2.LoadFromFile("file.png"); rs2._30_Update(); rs2.Close(); rs._30_Update(); rs.Close(); </code></pre> <p>This works but the file is in the first row of the tabel all the time and i can´t figure out how to get the right row. If i try to add a WHERE clause to the SELECT statement ill get a " Too few parameters. Expected 2." exception.</p> <p><em>If anyone knows a way to story my Byte[] (or a image) into the database an get it out again please let me know!</em></p> <p><strong>Please don´t give me links to:</strong></p> <p><a href="http://office.microsoft.com/en-us/access-help/using-multivalued-fields-in-queries-HA010149297.aspx#BM4.6" rel="nofollow noreferrer">http://office.microsoft.com/en-us/access-help/using-multivalued-fields-in-queries-HA010149297.aspx#BM4.6</a></p> <p><a href="http://www.mikesdotnetting.com/Article/123/Storing-Files-and-Images-in-Access-with-ASP.NET" rel="nofollow noreferrer">http://www.mikesdotnetting.com/Article/123/Storing-Files-and-Images-in-Access-with-ASP.NET</a></p> <p><a href="http://www.sitepoint.com/forums/showthread.php?t=666928" rel="nofollow noreferrer">http://www.sitepoint.com/forums/showthread.php?t=666928</a></p> <p><a href="http://www.eggheadcafe.com/software/aspnet/35103540/multivalued-fields-in-access-2007-with-c-ado.aspx" rel="nofollow noreferrer">http://www.eggheadcafe.com/software/aspnet/35103540/multivalued-fields-in-access-2007-with-c-ado.aspx</a></p> <p><a href="https://stackoverflow.com/questions/779211/programmatically-managing-microsoft-access-attachment-typed-field-with-c-net">Programmatically managing Microsoft Access Attachment-typed field with .NET</a></p> <p>Thanks for your help guys.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USGpx
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POStore Byte[] in Access 2010
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POStore Byte[] in Access 2010
      1. USRobert Harvey
      1. VTFavorite
    3. VO
      singulars
      1. POStore Byte[] in Access 2010
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf all else fails, you could always encode the data yourself and store it as a string. You could parse your bytes into Hex, delimit them for storage, and then pass them into a method to undelimit them upoin retreval. It would be a very hacked, bloated solution, but it would work. On second thought, don't do this. =)
      singulars
      1. POStore Byte[] in Access 2010
      1. USGeorge Johnston
    2. COThanks JonH, but there are a couple of reasons for me to have just one file with all information, so e.g. one has to send just this single file to other people.
      singulars
      1. POStore Byte[] in Access 2010
      1. USGpx
    3. COLove your comment George! Thought about that, but as you say - won´t do it.
      singulars
      1. POStore Byte[] in Access 2010
      1. USGpx
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload