Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked vs Embedded ole object

Status
Not open for further replies.
AncientTiger

AncientTiger

Programmer
Jul 5, 2001
238
US
I'm trying to insert a .jpg file into a OLE field, and I need to know how to EMBED the file into the database, not just link to it. Is there a way to tell JetSQL the difference during runtime (I'm using Visual basic)? Something like

INSERT INTO PICS (PIC,PICNAME-EMBED) VALUES ('C:\myimage.jpg','My Image')

I'm at a loss....


------------------------------------
[yinyang] 18 years of programming, and still learning every day! [yinyang]
 
Sort by date Sort by votes
Did I stump everyone on this, or did I just fart in church?


------------------------------------
[yinyang] 18 years of programming, and still learning every day! [yinyang]
 
Upvote 0 Downvote
I'm looking to do the same sort of thing, did you ever find a solution?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Fish521
  • Locked
  • Question
Run Delete Query on Linked Sharepoint List
Replies
8
Views
183
Andrzejek
Andrzejek
VickyC
  • Locked
  • Question
question about using embedded SQL insted of saved query 1
Replies
2
Views
43
PHV
PHV
vba317
  • Locked
  • Question
Runtime error 1004 Application -defined or object -defined error
Replies
0
Views
26
vba317
vba317
billheath
  • Locked
  • Question
requetin a particular date vs all dates
Replies
4
Views
52
dhookom
dhookom
barnettjacob
  • Locked
  • Question
Access SQL Query to get Earliest date from linked table 2
Replies
9
Views
88
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top