Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 12th, 2004, 05:30 AM
Authorized User
 
Join Date: Nov 2003
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update query

I need to update a table with pictures. The field to be updated is type Ole Object. The primary key corresponds to the file name of the picture to be updated. eg. PK = Abs403, Ole field = Abs403.jpg.
 
Old June 13th, 2004, 10:29 PM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

If you are using ASP, then check the following URL:

http://www.codeproject.com/useritems..._from_Data.asp

If you want this in ASP.NET then check the following:

http://www.dotnetjunkies.com/HowTo/C...8DBEC7F25.dcik

Hope this helps..

Om Prakash
 
Old June 14th, 2004, 01:46 AM
Authorized User
 
Join Date: Nov 2003
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

no, I am not using ASP.
 
Old June 14th, 2004, 03:04 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Do you want to write update statement to update images?

If yes, then i don't think u can, because u need the binary content to update.

are u using any front-end?

Om Prakash





Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Query Help dalezjc Classic ASP Basics 8 March 18th, 2008 08:49 AM
Update Query rsm42 ASP.NET 1.0 and 1.1 Basics 0 April 9th, 2007 09:32 AM
I solved insert query.now see this Update Query. amit_mande@yahoo.com VB.NET 2002/2003 Basics 2 September 21st, 2006 12:48 AM
Update query trab Access 1 May 11th, 2006 03:58 PM
Please Help me about UPDATE query huyremy VB Databases Basics 8 September 29th, 2004 03:45 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.