Prev: MS Access query
Next: Command Button wizard in 2007
From: Edward on 17 Jun 2010 07:37
MS Access 2002 SP3/SQL Express

My client has a form with a BoundObject control on it whose control
source is an Image column in a SQL Server database. Today, she tried
to add a new picture to a record and it's not working correctly - the
picture is distorted and shows the title of it, whereas on my system
it works correctly.

This is a screen grab from the client's machine:

http://www.flickr.com/photos/30588773(a)N04/4708957386/

This is a screen grab from my machine:

http://www.flickr.com/photos/30588773(a)N04/4708315721/

Prior to today (although she hasn't tried it for a few weeks or
months) the picture upload worked correctly. Also, if she loads an
existing record with a picture it displays correctly - it's only
today's picture that doesn't. We are both using exactly the same
file. I've checked the properties for the BoundObject control and
they are the same - particularly SizeMode = Stretch

The only difference of which I'm aware is that I'm running MS Access
2003 but that doesn't explain why this USED to work for her when
adding new pictures, and STILL works for her when loading existing
records.

Thanks

Edward
From: Tom van Stiphout on 17 Jun 2010 22:17
On Thu, 17 Jun 2010 04:37:54 -0700 (PDT), Edward
<teddysnips(a)hotmail.com> wrote:

I would delete the pic (in the record) and try again.
Then try again on another workstation.

-Tom.
Microsoft Access MVP



>MS Access 2002 SP3/SQL Express
>
>My client has a form with a BoundObject control on it whose control
>source is an Image column in a SQL Server database. Today, she tried
>to add a new picture to a record and it's not working correctly - the
>picture is distorted and shows the title of it, whereas on my system
>it works correctly.
>
>This is a screen grab from the client's machine:
>
>http://www.flickr.com/photos/30588773(a)N04/4708957386/
>
>This is a screen grab from my machine:
>
>http://www.flickr.com/photos/30588773(a)N04/4708315721/
>
>Prior to today (although she hasn't tried it for a few weeks or
>months) the picture upload worked correctly. Also, if she loads an
>existing record with a picture it displays correctly - it's only
>today's picture that doesn't. We are both using exactly the same
>file. I've checked the properties for the BoundObject control and
>they are the same - particularly SizeMode = Stretch
>
>The only difference of which I'm aware is that I'm running MS Access
>2003 but that doesn't explain why this USED to work for her when
>adding new pictures, and STILL works for her when loading existing
>records.
>
>Thanks
>
>Edward
From: Edward on 18 Jun 2010 02:55
On 18 June, 03:17, Tom van Stiphout <tom7744.no.s...(a)cox.net> wrote:
> On Thu, 17 Jun 2010 04:37:54 -0700 (PDT), Edward
>
> <teddysn...(a)hotmail.com> wrote:
>
> I would delete the pic (in the record) and try again.
> Then try again on another workstation.
>
> -Tom.
> Microsoft Access MVP
>
>
>
> >MS Access 2002 SP3/SQL Express
>
> >My client has a form with a BoundObject control on it whose control
> >source is an Image column in a SQL Server database.  Today, she tried
> >to add a new picture to a record and it's not working correctly - the
> >picture is distorted and shows the title of it, whereas on my system
> >it works correctly.
>
> >This is a screen grab from the client's machine:
>
> >http://www.flickr.com/photos/30588773(a)N04/4708957386/
>
> >This is a screen grab from my machine:
>
> >http://www.flickr.com/photos/30588773(a)N04/4708315721/
>
> >Prior to today (although she hasn't tried it for a few weeks or
> >months) the picture upload worked correctly.  Also, if she loads an
> >existing record with a picture it displays correctly - it's only
> >today's picture that doesn't.  We are both using exactly the same
> >file.  I've checked the properties for the BoundObject control and
> >they are the same - particularly SizeMode = Stretch
>
> >The only difference of which I'm aware is that I'm running MS Access
> >2003 but that doesn't explain why this USED to work for her when
> >adding new pictures, and STILL works for her when loading existing
> >records.
>
> >Thanks
>
> >Edward- Hide quoted text -
>
> - Show quoted text -

It's got quite weird. The Access app is hosted on a terminal server,
so in the end I logged in remotely and I was able to upload the
picture correctly! So here we have two users, both using the same
application, sitting on the same record on the same back-end,
uploading the same picture, with two different outcomes. The ONLY
difference is that I'm accessing the system via a desktop PC via an
RDP, whereas the client is accessing the system over the LAN.

Thoughts?

Edward
From: Arvin Meyer on 19 Jun 2010 03:12
I doubt that there was a spontaneous change. More than likely, someone was
fiddling around in design view. Send her a copy of the front-end from your
machine, saved as an MDE, and I doubt she'll ever have the problem again.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


"Edward" <teddysnips(a)hotmail.com> wrote in message
news:85253e35-621f-4c0c-941f-e6d5abb139cb(a)5g2000yqz.googlegroups.com...
> MS Access 2002 SP3/SQL Express
>
> My client has a form with a BoundObject control on it whose control
> source is an Image column in a SQL Server database. Today, she tried
> to add a new picture to a record and it's not working correctly - the
> picture is distorted and shows the title of it, whereas on my system
> it works correctly.
>
> This is a screen grab from the client's machine:
>
> http://www.flickr.com/photos/30588773(a)N04/4708957386/
>
> This is a screen grab from my machine:
>
> http://www.flickr.com/photos/30588773(a)N04/4708315721/
>
> Prior to today (although she hasn't tried it for a few weeks or
> months) the picture upload worked correctly. Also, if she loads an
> existing record with a picture it displays correctly - it's only
> today's picture that doesn't. We are both using exactly the same
> file. I've checked the properties for the BoundObject control and
> they are the same - particularly SizeMode = Stretch
>
> The only difference of which I'm aware is that I'm running MS Access
> 2003 but that doesn't explain why this USED to work for her when
> adding new pictures, and STILL works for her when loading existing
> records.
>
> Thanks
>
> Edward


 | 
Pages: 1
Prev: MS Access query
Next: Command Button wizard in 2007