Copyimage from msaccess to mssql vb script

Copyimage from msaccess to mssql vb script code#

Thank you very much in advance for your support! So, somehow the generated binary file created from MS Access must be different from my images, which I'm uploading with python to the MySQL database, but I don't know how. I just realized that the images (.bmp) can be displayed in a form, if they are inserted by the import-function of MS Access into the linked table. I am not really happy with this solution because the total size of the images is about 500 MB, which will probably be downloaded and stored every time!?Дoes anybody know a good way to display these images!? How do I display an image from Sql Server with Microsoft Access?.

Copyimage from msaccess to mssql vb script code#

There are also some vba code snippets out there, which dump the BLOB to a temp file and then the form is referring to the file-path: I saw this and it's working great for single-forms, but as far as I know it can't be used for continuous-forms: I linked the MySQL table in MS Access through the ODBC-driver and I'm able to see the data in the MS Access table, but displaying the images is not an easy task. The images in the MySQL database are stored in a BLOB field. The data from MySQL is containing some images, which should be displayed in a continuous-form in MS Access. I'm using MS Access to visualize the data from a MySQL database.