Image path in Access 2000 database; want to display photo in form and on web

[Ken]

I have a database called autographs.mdb that is in the "XYZ" folder in
the "database" folder. I have a form in the database that I want to
display a photo of the celeb on. The photos are in a "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\graphics\photo.jpg). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\photo.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\photo.jpg" would display the photo in the form
but it does not.

Ken

[Jerry Boone]

Going to take some coding...

For the web side, look into using ASP (vbscript enabled web pages),
connecting to the database using ADO (activex data objects), and working
with Server.Mappath for getting the folder the images are stored in. A good
ASP book goes a long way here. It's possible this may all be more than you
want to do with the learning curve involved.

Good luck!

:)
"Ken" <ne***********@mail.com> wrote in message
news:9b**************************@posting.google.c om...

I have a database called autographs.mdb that is in the "XYZ" folder in
the "database" folder. I have a form in the database that I want to
display a photo of the celeb on. The photos are in a "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\graphics\photo.jpg). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\photo.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\photo.jpg" would display the photo in the form
but it does not.

Ken

[MeadeR]

since you'll be using a web server for the images - why not have both
the web code and access code reference the URL....

ne***********@mail.com (Ken) wrote in message news:<9b**************************@posting.google. com>...

I have a database called autographs.mdb that is in the "XYZ" folder in
the "database" folder. I have a form in the database that I want to
display a photo of the celeb on. The photos are in a "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\graphics\photo.jpg). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\photo.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\photo.jpg" would display the photo in the form
but it does not.

Ken

[Ken]

> Thanks for replying. I put the following code in my imageframe code:

Private Sub Form_Current()
On Error Resume Next
MyPath = "E:\Programs\CFusionMX\wwwroot\Starsigners\h5zrig1 u\"
Me![ImageFrame].Picture = MyPath & Me![ImagePath]
End Sub

Private Sub ImagePath_AfterUpdate()
On Error Resume Next
MyPath = "E:\Programs\CFusionMX\wwwroot\Starsigners\h5zrig1 u\"
Me![ImageFrame].Picture = MyPath & Me![ImagePath]
End Sub

That let me keep just the file name in the text field. Do you see
anyhting wrong with the code? I am uploading the database to a web
page and that seems to work locally.

I am linking the files; the ImageFrame field is the image control.
Thanks to all responders; having trouble getting a reply thru Google!

Ken

"Jerry Boone" <je***@gomaps.com.nospam> wrote in message news:<%i***************@newssvr22.news.prodigy.com >... Going to take some coding...

For the web side, look into using ASP (vbscript enabled web pages),
connecting to the database using ADO (activex data objects), and working
with Server.Mappath for getting the folder the images are stored in. A good
ASP book goes a long way here. It's possible this may all be more than you
want to do with the learning curve involved.

Good luck!

:)
"Ken" <ne***********@mail.com> wrote in message
news:9b**************************@posting.google.c om...

I have a database called autographs.mdb that is in the "XYZ" folder in
the "database" folder. I have a form in the database that I want to
display a photo of the celeb on. The photos are in a "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\graphics\photo.jpg). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\photo.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\photo.jpg" would display the photo in the form
but it does not.

Ken