I'm not much of a SQL guy here, so this may be really easy to do but I cant figure it out or find help online.
I'm programming in Visual Basic within a Microsoft Access 2007 database. I have a SQL 2005 server.
My database needs to update the contents of an "image" datatype field on a database on the SQL server. I dont think that it matters but the content Im trying to save is RTF text.
I do not need to READ anything from this field simply WRITE my update to it.
I already have an ODBC link setup and I can already set the image field to null or to a string value (although that, of course, comes out garbled). Ive attached code that I have that will successfully set the field to null.
I need to know how to take a visual basic string (which contains my RTF text & RTF codes) and convert it so that it can be stored in this field.
The creators of the database gave me the following query that will allow me to pull the data OUT of the field correctly if I use SQL Management Studio:
MMENTS)) from EA7STUDENTGRADES
I thought I could easily reverse engineer this query and apply it to Visual Basic, but it appears to be beyond me!
Set vCurrentTable = CurrentDb().OpenRecordset("SELECT dbo_EA7STUDENTGRADES.* FROM dbo_EA7STUDENTGRADES, dbOpenDynaset, dbSeeChanges)
vCurrentTable!COMMENTS = null