How to insert graphics in Access DB through SQL

[thesleepylizard]

Hi everyone,

I have an Access database which has a OLE object field containing a picture. In my program, I use Crystal Reports, which then uses that pictures as a BLOB field to display the company's logo.

Now, this program will be used by a variety of people who could potentially want different logos. So, I need to provide a way to insert graphics data into this Access DB field, so that it will be displayed on the report.

All of my interactions with the DB are though standard SQL queries - I'm not using any of the fancy features of ADO like control linking and bookmarks and so on, it's all through Recordset.Open or DBC.Execute.

Now how on earth would I insert graphics data through ordinary queries?? It would have to be something like:

INSERT INTO tblLogo (Graphics) VALUES (L@#<@#R@#019J434E5FWM:5F6L6EW9Fdj0923...);

Well, you get the idea. So 2 questions:

1) How could I let my users customize their logo in this scenario? (I need to know this)

2) How can you insert graphics into an Access database through normal SQL queries? (I don't need to know this if there's another way to do it, I'm just curious though)

Thanks for you time,
-Sleepy