Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default Database Folder - has it changed?

Status
Not open for further replies.

JoeB99708

Technical User
Nov 19, 2012
1
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top