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

 

I love those 3D pictures and look forward to seeing your project. How
about abandoning your Access database and recreating its functions as a
website in HTML? I also use Access 2003, and run a simple hand-crafted
website for a walking club, but have never tried converting an Access
file into HTML.
Dave W

On 18/02/2019 15:38, 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: Dave Williams <davewillgmale@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

---

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

.

__,_._,___