[Solved] Issue With Image Storage and its path, working with network share drive Y.

Hello Ursh,

I'm facing issue with my database working with images. Major issue is the location path of the images. While i'm using main PC it upload images in "D:\Server\Images" path and in Network share drive it upload in "Y:\Images" path. Due to that Images wont be display if one user uploads images and other user can't see that images displayed only the file path is display.

jpgNm = CurrentProject.Path & "\Customer Details\Images\" & jpgCd & ".jpg"

FileCopy myfile, jpgNm
Me.ProfileIMG.Picture = jpgNm 'Display Image
Me.ProfilePic = jpgNm 'Inserting the address or the path as text into the field

What will be the correct way to insert images to display in both the database? Please help me as i'm in the final stage of my project. Because of this i'm stuck. Previously i was using "Attachement" option because of that file size increased and after seeing your tutorial i'm using your method of handling images.