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: randlov@post9.tele.dk
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar