A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A2007 - OLE vs. Attachements



 
 
Thread Tools Display Modes
  #1  
Old October 11th, 2009, 09:23 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Jay Oken
external usenet poster
 
Posts: 13
Default A2007 - OLE vs. Attachements

I would like to add a picture to a record but do not know the best way to do
it. From what I can see OLE gives the option to "link" to the picture file
rather than imbed the picture in the database which then bloats my database.
The "attachment" type field has a nicer interface when I put it on a form
but bloats the database. Is there a way to use the Attachment field type but
have it be a link to the picture.

Thanks,
J


  #2  
Old October 11th, 2009, 10:19 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default A2007 - OLE vs. Attachements

Store all your pictures in a common folder. Each picture will have an unique
path. Store the complete path in a text field in your table. To display your
pictures in a form or report, add an image control (see the toolbox). Set
the Picture property of the image control to the field that holds the path.

Steve



"Jay Oken" wrote in message
...
I would like to add a picture to a record but do not know the best way to
do it. From what I can see OLE gives the option to "link" to the picture
file rather than imbed the picture in the database which then bloats my
database. The "attachment" type field has a nicer interface when I put it
on a form but bloats the database. Is there a way to use the Attachment
field type but have it be a link to the picture.

Thanks,
J



  #3  
Old October 11th, 2009, 11:14 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Mark Andrews[_2_]
external usenet poster
 
Posts: 600
Default A2007 - OLE vs. Attachements

Have you considered using the attachment field and bloating?
Pros and cons for each approach. A picture to a contact record is probably
the typical senerio
Microsoft envisioned for using the attachment field "as is". Not storing
tons and tons of graphics etc...
You get to see a preview of the image (for most formats). I believe they
made it better on the "amount of bloating that occurs".

I don't think you can use the attachment field to hold a link.
You can add/extract attachments via code to move things back and forth from
the filesystem to the database.

HTH
Mark

"Jay Oken" wrote in message
...
I would like to add a picture to a record but do not know the best way to
do it. From what I can see OLE gives the option to "link" to the picture
file rather than imbed the picture in the database which then bloats my
database. The "attachment" type field has a nicer interface when I put it
on a form but bloats the database. Is there a way to use the Attachment
field type but have it be a link to the picture.

Thanks,
J



  #4  
Old October 11th, 2009, 11:21 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
StopThisAdvertising
external usenet poster
 
Posts: 334
Default A2007 - OLE vs. Attachements


"Steve" schreef in bericht
...
Store all your pictures in a common folder. Each picture will have an unique path. Store
the complete path in a text field in your table. To display your pictures in a form or
report, add an image control (see the toolbox). Set the Picture property of the image
control to the field that holds the path.

Steve



--
Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

OP look at
http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's
a shame !!)

For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post...
We warned him a thousand times... Sad, but he is not willing to stop advertising...

He is just toying with these groups... advertising like hell... on and on... for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...

== We are totally 'finished' with $teve now...
== Killfile 'StopThisAdvertising' and you won't see these mails....

Arno R


  #5  
Old October 13th, 2009, 05:21 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
JohnLute
external usenet poster
 
Posts: 299
Default A2007 - OLE vs. Attachements

This is ridiculous. So let's not ban a person who is clearly violating terms.
Let's instead create a MASSIVE online "info-attack" on them. Just ridiculous.
So reminiscent of the Aaron Kempf drama. If Steve is the person that you
claim then why oh, WHY are they NOT simply banned and their multitude of
posts simply deleted?

Bordering on stupid.

--
www.Marzetti.com


"StopThisAdvertising" wrote:


"Steve" schreef in bericht
...
Store all your pictures in a common folder. Each picture will have an unique path. Store
the complete path in a text field in your table. To display your pictures in a form or
report, add an image control (see the toolbox). Set the Picture property of the image
control to the field that holds the path.

Steve



--
Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

OP look at
http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's
a shame !!)

For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post...
We warned him a thousand times... Sad, but he is not willing to stop advertising...

He is just toying with these groups... advertising like hell... on and on... for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...

== We are totally 'finished' with $teve now...
== Killfile 'StopThisAdvertising' and you won't see these mails....

Arno R



  #6  
Old October 13th, 2009, 05:44 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default A2007 - OLE vs. Attachements

In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show?
  #7  
Old October 13th, 2009, 06:40 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
JohnLute
external usenet poster
 
Posts: 299
Default A2007 - OLE vs. Attachements

I don't see it, either. So in this instance one could argue that StopThis
Advertising is in violation of harrassment.

These kinds of "wars" ruin things for everyone. StopThisAdvertising claims,
"We warned him a thousand times..."

Who is "we" and what/who has given "we" the authority to warn ANYBODY? I
just reviewed the TOU:
http://www.microsoft.com/info/cpyright.mspx#E1

These don't seem to have been altered for a couple years. If Steve is such a
violator then he should be properly reported to MS.

Steve appears to be a troll and to have taken on other identities. So if it
can be so easily proven then simply do so and be done with it. I'm entirely
annoyed by self-appointed forum police!

Considering that Steve has been warned "a thousand times" yet is still free
to post makes it CLEAR that those who have been warning him are entirely out
of line.

---
www.Marzetti.com


"Piet Linden" wrote:

In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show?

  #8  
Old October 13th, 2009, 07:45 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default A2007 - OLE vs. Attachements

John,

I am not defedning anyone but please note that the TOU you preseted is for
Software. The Rules of Conduct for the Newsgroup can be found here...
http://www.microsoft.com/library/gal...RulesofConduct.
And to quote...

"Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance on Microsoft products and services. We ask
that you refrain from posting advertisements or solicitations that do not
pertain directly to the intended use and purpose of the newsgroup or chat."


1. No, I have to agree I do not see it in this posting either. HOWEVER, I
have seen it as much as 9 (nine) times ALL in seperate posts.

2. and 3. As for who the "We" are please refer to postings where Steve has
advertised. If you do a search on Steve you will find the "We" and the
solicitations.

3. He has been reported several times and has had to make several
adjustments to post here. I am not going to defend Steve or
StopThisAdvertising. I will say if you don't want to see either one please
use Killfile.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JohnLute" wrote in message
...
I don't see it, either. So in this instance one could argue that StopThis
Advertising is in violation of harrassment.

These kinds of "wars" ruin things for everyone. StopThisAdvertising
claims,
"We warned him a thousand times..."

Who is "we" and what/who has given "we" the authority to warn ANYBODY? I
just reviewed the TOU:
http://www.microsoft.com/info/cpyright.mspx#E1

These don't seem to have been altered for a couple years. If Steve is such
a
violator then he should be properly reported to MS.

Steve appears to be a troll and to have taken on other identities. So if
it
can be so easily proven then simply do so and be done with it. I'm
entirely
annoyed by self-appointed forum police!

Considering that Steve has been warned "a thousand times" yet is still
free
to post makes it CLEAR that those who have been warning him are entirely
out
of line.

---
www.Marzetti.com


"Piet Linden" wrote:

In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show?



  #9  
Old October 13th, 2009, 07:59 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
JohnLute
external usenet poster
 
Posts: 299
Default A2007 - OLE vs. Attachements

Thanks for the clarification, Gina. I'm certainly not defending anyone,
either. I'm simply saying that the "info-attack" on Steve is as ridiculous
and annoying as Steve's trolling for $$$.

This smacks of the Aaron Kempf issue. Good GAWSH - if the Rules of Conduct
are so explicit and clear than why in the world are these things allowed to
blow up like this?

Simply ban the offender and get on with life. I really appreciate these
forums but I find these playground antics just a bit much and feel compelled
to voice my irritation.

--
www.Marzetti.com


"Gina Whipp" wrote:

John,

I am not defedning anyone but please note that the TOU you preseted is for
Software. The Rules of Conduct for the Newsgroup can be found here...
http://www.microsoft.com/library/gal...RulesofConduct.
And to quote...

"Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance on Microsoft products and services. We ask
that you refrain from posting advertisements or solicitations that do not
pertain directly to the intended use and purpose of the newsgroup or chat."


1. No, I have to agree I do not see it in this posting either. HOWEVER, I
have seen it as much as 9 (nine) times ALL in seperate posts.

2. and 3. As for who the "We" are please refer to postings where Steve has
advertised. If you do a search on Steve you will find the "We" and the
solicitations.

3. He has been reported several times and has had to make several
adjustments to post here. I am not going to defend Steve or
StopThisAdvertising. I will say if you don't want to see either one please
use Killfile.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JohnLute" wrote in message
...
I don't see it, either. So in this instance one could argue that StopThis
Advertising is in violation of harrassment.

These kinds of "wars" ruin things for everyone. StopThisAdvertising
claims,
"We warned him a thousand times..."

Who is "we" and what/who has given "we" the authority to warn ANYBODY? I
just reviewed the TOU:
http://www.microsoft.com/info/cpyright.mspx#E1

These don't seem to have been altered for a couple years. If Steve is such
a
violator then he should be properly reported to MS.

Steve appears to be a troll and to have taken on other identities. So if
it
can be so easily proven then simply do so and be done with it. I'm
entirely
annoyed by self-appointed forum police!

Considering that Steve has been warned "a thousand times" yet is still
free
to post makes it CLEAR that those who have been warning him are entirely
out
of line.

---
www.Marzetti.com


"Piet Linden" wrote:

In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show?




  #10  
Old October 13th, 2009, 08:37 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default A2007 - OLE vs. Attachements

The problem is that these newsgroups aren't moderated, nor can they be.

You're using Microsoft's web interface to post, but you're actually posting
to NNTP newsgroups, not a website.

The groups exist on a multitude of servers, not simply the ones that
Microsoft administers themselves (msnews.microsoft.com). While Microsoft
conceivably could delete posts originating on their server, they would be
unable to delete posts originating on other servers.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JohnLute" wrote in message
...
Thanks for the clarification, Gina. I'm certainly not defending anyone,
either. I'm simply saying that the "info-attack" on Steve is as ridiculous
and annoying as Steve's trolling for $$$.

This smacks of the Aaron Kempf issue. Good GAWSH - if the Rules of Conduct
are so explicit and clear than why in the world are these things allowed
to
blow up like this?

Simply ban the offender and get on with life. I really appreciate these
forums but I find these playground antics just a bit much and feel
compelled
to voice my irritation.

--
www.Marzetti.com


"Gina Whipp" wrote:

John,

I am not defedning anyone but please note that the TOU you preseted is
for
Software. The Rules of Conduct for the Newsgroup can be found here...
http://www.microsoft.com/library/gal...RulesofConduct.
And to quote...

"Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance on Microsoft products and services. We
ask
that you refrain from posting advertisements or solicitations that do not
pertain directly to the intended use and purpose of the newsgroup or
chat."


1. No, I have to agree I do not see it in this posting either. HOWEVER,
I
have seen it as much as 9 (nine) times ALL in seperate posts.

2. and 3. As for who the "We" are please refer to postings where Steve
has
advertised. If you do a search on Steve you will find the "We" and the
solicitations.

3. He has been reported several times and has had to make several
adjustments to post here. I am not going to defend Steve or
StopThisAdvertising. I will say if you don't want to see either one
please
use Killfile.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JohnLute" wrote in message
...
I don't see it, either. So in this instance one could argue that
StopThis
Advertising is in violation of harrassment.

These kinds of "wars" ruin things for everyone. StopThisAdvertising
claims,
"We warned him a thousand times..."

Who is "we" and what/who has given "we" the authority to warn ANYBODY?
I
just reviewed the TOU:
http://www.microsoft.com/info/cpyright.mspx#E1

These don't seem to have been altered for a couple years. If Steve is
such
a
violator then he should be properly reported to MS.

Steve appears to be a troll and to have taken on other identities. So
if
it
can be so easily proven then simply do so and be done with it. I'm
entirely
annoyed by self-appointed forum police!

Considering that Steve has been warned "a thousand times" yet is still
free
to post makes it CLEAR that those who have been warning him are
entirely
out
of line.

---
www.Marzetti.com


"Piet Linden" wrote:

In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show?






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.