Hi
New to the forum so please excuse me if this is already answered
I have a database of 2800 records all with 6 images - which until recentley worked with no problems.
The Main database is on a Work Server Directory L:
Whilst working remotley I have 5 Users eachwitha database with this as the default Database folder
When Access opened it stated "cannot connect to L:" but opened and we could work on the remote database
Within the the form I have the following code
Private Sub Form_Current()
If IsNull(Me![txtImageName]) Then
Me![ImageFrame].Picture = "c:\users\public\documents\crest.jpg"
Else
Me![ImageFrame].Picture = Me![txtImageName]
End If
If IsNull(Me![PhotoW]) Then
Me![Photo West].Picture = ""
Else
Me![Photo West].Picture = Me![PhotoW]
End If
If IsNull(Me![PhotoN]) Then
Me![Photo North].Picture = ""
Else
Me![Photo North].Picture = Me![PhotoN]
End If
If IsNull(Me![PhotoS]) Then
Me![Photo South].Picture = ""
Else
Me![Photo South].Picture = Me![PhotoS]
End If
If IsNull(Me![PhotoE]) Then
Me![Photo East].Picture = ""
Else
Me![Photo East].Picture = Me![PhotoE]
End If
End Sub
Which allowed the user to add records and the images to display on their Laptop
Now Access want to be connect to L:\ all the time and images will not display unless conntected and the images are on L:
Help
New to the forum so please excuse me if this is already answered
I have a database of 2800 records all with 6 images - which until recentley worked with no problems.
The Main database is on a Work Server Directory L:
Whilst working remotley I have 5 Users eachwitha database with this as the default Database folder
When Access opened it stated "cannot connect to L:" but opened and we could work on the remote database
Within the the form I have the following code
Private Sub Form_Current()
If IsNull(Me![txtImageName]) Then
Me![ImageFrame].Picture = "c:\users\public\documents\crest.jpg"
Else
Me![ImageFrame].Picture = Me![txtImageName]
End If
If IsNull(Me![PhotoW]) Then
Me![Photo West].Picture = ""
Else
Me![Photo West].Picture = Me![PhotoW]
End If
If IsNull(Me![PhotoN]) Then
Me![Photo North].Picture = ""
Else
Me![Photo North].Picture = Me![PhotoN]
End If
If IsNull(Me![PhotoS]) Then
Me![Photo South].Picture = ""
Else
Me![Photo South].Picture = Me![PhotoS]
End If
If IsNull(Me![PhotoE]) Then
Me![Photo East].Picture = ""
Else
Me![Photo East].Picture = Me![PhotoE]
End If
End Sub
Which allowed the user to add records and the images to display on their Laptop
Now Access want to be connect to L:\ all the time and images will not display unless conntected and the images are on L:
Help