photos in database

[Jan]

I am trying to add photos to an existing database for a website.
I added the photo and now it appears in place of all photos in site. I
deleted the image and it still appears in place of all photos. Help. I made
a copy of the datebase. How do I replace the database I changed with my copy?

 

[Arvin Meyer [MVP]]

I am trying to add photos to an existing database for a website.
I added the photo and now it appears in place of all photos in site. I
deleted the image and it still appears in place of all photos. Help. I
made
a copy of the datebase. How do I replace the database I changed with my
copy?

To be safe, rename the existing database and put the copy in the same
location.

 

[Evi]

The reason this happened is because the many different photos that were
originally on the website are stored in a table in the database, either as a
file path (if the Photo field is a string field) or as an OLE object if the
Data Type for that field is an OLE Object.

You deleted this linked photo and put your photo there. In fact, you need to
go to the table or form where you input data and enter your photo in the
field either as a file path which includes the file name and file extension
or by clicking on your record, going to Insert on the Toolbar then choose
perhaps Microsoft Photo Editor, choose Create From File and browse to your
photo.
Evi

 

[Jan]

How do I go about putting a copy of my database into the same location? This
is the first I have worked with databases and I am nervous about going into
the website and deleting one and replace it? Is it as easy as dragging in a
new page?
Thanks for your help,

 

[Jan]

Do I insert all the photos into the images folder first, then when I type
into the data base, the images are called up? If I have multiple images on a
page, do I save each one as a seperate name and type that into the database?
Thanks in advance,

 

[Evi]

Rather than deleteing the old one, rename it before you put your copy in its
place.
When you are sure it is all working as it was before, then quietly delete
the renamed version.
You have my sympathy! I can just imagine doing exactly the same thing
Evi

 

[Arvin Meyer [MVP]]

If you insert, and properly name all your images, my free utility will build
the table for you.

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com