How can I bypass the MS Access 2 GB database limitation (for displaying images)?

Question

ORIGINAL QUESTION
(How can I display images from a MySQL database in an Access 2007 form?)

I would like to use Access 2007 to interact with a MySQL database and display images and other data in a form.

I already have an Access 2007 application that I don’t want to change much if I can help him. I just don't know what type of data will work. "Attachment data type" is not supported in MySQL. In addition, my client wants to be able to open and edit the image.


SOLVING THE UPDATE QUESTION
(How can I get around the 2 GB database limitation for MS Access (for displaying images)?)

(1) Save the image file names in MS Access
(2) Use VBA to dynamically display them in a form (see How to display images from a folder in a form, report, or data access page ).

To make images editable:
(1) Make sure the file type (for example, ".jpg") is associated with the selected image editor.
(2) Using the same variable names as in the article mentioned above , add the following code to the form in which it is located ImageFrame(see How to open a file in your application by default using VBA )

Private Sub ImageFrame_Click()
    Application.FollowHyperlink (txtImageName)
End Sub

Several other sources that may be helpful

Perl, MySQL and Blobs

VB, MySQL and Blobs

Using Images in Access

Using MS Access as a front-end for PostgreSQL .

Special thanks to MindStalker for his comment that led me to start another Googling round.

Answer 1

. , .