Re: [MS_AccessPros] Placing 30,000 images on a server

 

Welcome, Peter

Access can generally only show images if you download them to display them, which defeats the purpose of having them online.

However, there is another way. You can use the web browser control to display a little HTML file that references the image (code can be created to write these for you automatically). I am creating an example for you.

~crystal

On 2/18/2019 9:38 AM, randlov@post9.tele.dk [MS_Access_Professionals] wrote:

I recently joined the group, and have already had good use from some of the discussions.

 

The Access database I work with contains almost 30,000 images (11GB) of stereoscopic cards from Denmark (the 3D pictures, which were very popular around 1900).

I want the db to be available for a wider audience and have the idea, that the images can be stored on a server (in the cloud?). The users should execute the 10MB db with the MS Access Runtime and the VBA code must find the jpg images on the server.

One of the predefined queries will open a form showing the image with relevant information.

ElseIf Dir(BilledSti) = [LBNR] & ".jpg" Then

    Me.Image12.Picture = strSAMLINGdrev & Left([LBNR], 2) & "\" & [LBNR] & ".jpg"

The string strSAMLINGdrev can typically have the value X:\RODS\SAMLING\, where X: is the drive where the images are. LBNR has the format AB1234, so the image shown in the form will e.g. be X:\RODS\SAMLING\AB\AB1234.jpg

Is it possible to replace part of this path with the IP address of a server? Like:

    Me.Image12.Picture = "Myhomepage.dk" &"\RODS\" & Left([LBNR], 2) & "\" & [LBNR] & ".jpg"

 

I "inherited" the registration of the Danish stereo cards in 1996 and converted the information to a MS Access db. I am now 77 years old and have not been able to find a person with interest in Danish stereo cards and skills in Access VBA code to take over, so I hope that placing the db online might make it survive some years more being an important part of Danish cultural history.

 

Looking forward to your advice.

Peter

 

It's a mdb file developed in MS Access 2003

Distributed with AccessRuntime2013

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___