Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
The table in that has two fields Emp Id and Emp Picture. If I execute the statement "INSERT INTO Emp values (1,"Savan. Ole Db Command class to create and alter tables in an MS Access DB. Append fld Set fld = Nothing Set tdf = Nothing it returns 12, which is equal to the VBA global constant db Memo (that's how I figured out how to do it, i.e., created a Hyperlink field in the Access UI, then checked its datatype). You would use two CHARACTER fields to represent the content of a hyperlink, one that contains the URL to the resource you want the hyperlink to link to (stored as plain text), and another that would hold the text that's shown in the browser (that is, if the text shown in the browser is different from the URL itself). You would store the url as you would any text and then when you're using it in your application you would create the hyperlink on that end. In VBA, this code does the trick (you'll have to figure out how to do this with DAO in C#): Dim tdf As DAO. It's also clear that the Hyperlink field type is only relevant if you're using the data from Access itself. You are best off creating a text field and only storing the image's path.You can then use an Image control to display the picture by setting the control's Picture property when you need to show it.Are you looking for the solution to your computer problem? This site is completely free -- paid for by advertisers and donations.If you're not already familiar with forums, watch our Welcome Guide to get started.Also, I don't think this has anything to do with it, but I do have my database split (FE and BE). Hi Nascar Baritone - did you ever figure this one out? I'm having a big problem with my linked ole object - I'm trying to link (in a subform) a dynamically generated ole unbound object source. If I go in to the table, delete the file, and Insert Object... I was under the impression that a linked OLE field would automatically update itself if changes were made to the linked document. I really don't want to have to go into the table and delete/insert every time I make a change to the file.