PC Review


Reply
Thread Tools Rate Thread

A2007 - OLE vs. Attachements

 
 
Jay Oken
Guest
Posts: n/a
 
      11th Oct 2009
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


 
Reply With Quote
 
 
 
 
Mark Andrews
Guest
Posts: n/a
 
      11th Oct 2009
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>



 
Reply With Quote
 
JohnLute
Guest
Posts: n/a
 
      13th Oct 2009
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" <(E-Mail Removed)> schreef in bericht
> news:4badne1-(E-Mail Removed)...
> > 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
> > (E-Mail Removed)
> >

>
> --
> 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
>
>
>

 
Reply With Quote
 
Piet Linden
Guest
Posts: n/a
 
      13th Oct 2009
In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show?
 
Reply With Quote
 
JohnLute
Guest
Posts: n/a
 
      13th Oct 2009
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?
>

 
Reply With Quote
 
Gina Whipp
Guest
Posts: n/a
 
      13th Oct 2009
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" <(E-Mail Removed)> wrote in message
news:BCA32A04-5783-4E61-ACEB-(E-Mail Removed)...
>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?
>>



 
Reply With Quote
 
JohnLute
Guest
Posts: n/a
 
      13th Oct 2009
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" <(E-Mail Removed)> wrote in message
> news:BCA32A04-5783-4E61-ACEB-(E-Mail Removed)...
> >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?
> >>

>
>
>

 
Reply With Quote
 
Douglas J. Steele
Guest
Posts: n/a
 
      13th Oct 2009
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" <(E-Mail Removed)> wrote in message
news:EC480ECE-A0F2-455D-8D1D-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:BCA32A04-5783-4E61-ACEB-(E-Mail Removed)...
>> >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?
>> >>

>>
>>
>>



 
Reply With Quote
 
JohnLute
Guest
Posts: n/a
 
      13th Oct 2009
Hi, Doug.

Well, then it seems to me that the *bigger* problem is poor planning. If I
were to initiate a fine forum like this (and it truly is fine) then I'd make
sure that I could actually ENFORCE the Rules of Conduct that people have been
asked to respect! Otherwise, why bother with any rules at all?

Personaly, I find the "info-attack" (I don't know what else to call it)
towards Steve far more disturbing than his trolling for $$$. It's downright
CREEPY. The fact that all of that effort goes for naught because ultimately,
the rules can't be enforced makes it more a travesty than anything.

Yikes!

--
www.Marzetti.com


"Douglas J. Steele" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:EC480ECE-A0F2-455D-8D1D-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:BCA32A04-5783-4E61-ACEB-(E-Mail Removed)...
> >> >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?
> >> >>
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Gina Whipp
Guest
Posts: n/a
 
      13th Oct 2009


--
Gina Whipp

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

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

"Steve" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> <........and has had to make several adjustments to post here. >
>
> Another one of your bold-faced lies, Bitch!!!!!!!!!!!!!!!
>
> I have never had to make any adjustments to post in the newsgroups.
>
> Steve
>
>
> "Gina Whipp" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:BCA32A04-5783-4E61-ACEB-(E-Mail Removed)...
>>>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?
>>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
A2007 References JimS Microsoft Access VBA Modules 1 18th Dec 2009 07:44 PM
A2007 - OLE vs. Attachements Jay Oken Microsoft Access Form Coding 31 20th Nov 2009 10:28 PM
Conversion to A2007 JimS Microsoft Access Form Coding 7 29th Oct 2008 03:00 PM
A2007 Suspected Bug Russell Microsoft Access Reports 0 6th Oct 2008 09:58 AM
This used to work in A97 but not in A2007 Mike D Microsoft Access Forms 1 26th Mar 2008 02:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:31 PM.