[AccessD] Imaging MS Access

[Gustav Brock]

Hi Kostas

With that volume of pictures, there's no way to store them in an Access file, limited to 2 GB as it is.
And as you already have the pictures - I guess - in appropriate size and format - I see no use for a third-party control; the native picture control will display the linked file right away - as you could see in the demo application.

Your task is to create a table that will provide a link between an ID and the physical path/filename of each picture.
I would store the ID, the path, and the clean filename. That would allow you to move the picture base(s) and then perform a simple update of the Path field.

If you store the pictures on a Windows Server 2012+, you could perhaps take advantage of the ReFS file system:

https://www.petri.com/4-reasons-refs-is-better-than-ntfs

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Kostas Konstantinidis
Sendt: 27. oktober 2017 09:34
Til: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Imaging MS Access

Hey Gustav,
Thank's a lot for this excellent link...

The last 35 years I have made a big research on all the History of the long and short Greek Films (more than 9400 movies) and actually what I need is to display with one sight for more than 15 pictures (the most  in high
resolution) for each of them.
So as you understand the number is extremely big (2.5Tb pictures) and what I am afraid is that MS Access will not  be able to manage it properly...

That's the reason I am looking for something like DBPix
(http://www.ammara.com/) but it's very expensive special if somebody needs to get it to work on several PC's on a network.

I attach the amara's answer to my email

> So, could you please confirm that DBPix 3 works on one-to-many?
That's really an Access capability, so yes - you can store multiple images per record.  This is typically achieved by creating a one-to-many table relationship and using a subform to view, add and edit the (multiple) images.

> And also if I need to use it into 4-5 different PC?s in private 
> network
how many licenses must I purchase for?

Our multi-user license supports one development system and unlimited runtime users.  Make sure you obtain and enter a multi-user license key on your development system before you start adding any dbPix 3.0 controls to your production application.  You can, of course, evaluate dbPix without a key, but note that if you start work on your production application before installing your license key you will need to delete any dbPix controls from that application and insert new ones after entering your license keycode.

Thank you and all the people answered to my question

/kostas 



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, October 26, 2017 10:00 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Imaging MS Access

Hi Kostas

Isn't it just a question about picture controls - and putting pictures into these?

Maybe you can get some ideas here:

https://www.experts-exchange.com/articles/29679/Show-pictures-directly-from-
URLs-in-Access-forms-and-reports.html

/gustav