Form Loading Slow From the Shared Folder

[injanib]

I have a database that holds students information. The back-end is stored on a shared folder in a workgroup environment. The pictures of the students are stored externally on a folder in the same share folder as the backend. The front ends are installed on 4 computers. The current event of the form looks into the folder in the shared folder to display the picture associated with each record. This causes the form to load up very slow. what can I do to speed this up. The code to display the images is:

strFullPath = "\\ComputerName\Database\Students\" & Me.txtStudentID & ".bmp"

If Dir(strFullPath) = "" Then
Forms!frmUpdateEnrollment.txtImage.Picture = ""
Else
Forms!frmUpdateEnrollment.txtImage.Picture = strFullPath
End If

The pictures are displayed properly. It is just that navigation between the records are very slow, specially when the form is loaded for the first time. the sizes of the pictures are below 100Kb.

Thanks in advance.

[injanib]

I take it back. the pictures do not display properly. It worked on the local machine. I didn't actually tested it on the network.

Before I had it as

strFullPath= CurrentProject.Path & "\Students\" & Me.txtStudentID & ".bmp"

This worked really well on the workstation, but since I have to put it on the network, I changed the path to that in my post above. It doesn't display the pictures and the forms load extremely slow.

[injanib]

Ok this is resolved. The problem was with the path.