Peculiar Problem

[Transentient]

I have a contacts database whic I created and use at work. The database file resides in a folder on the company network. The file was created using Access97.

I have incorporated Stephen Lebans module for changing the MDI client Background. I have imported all the necessary parts. I have made a small alteration to bypass the CommonDialog box, and set the background via code, as below:

fname = GetDBPath & "Applications Files\Graphics\MDIBackground.bmp"

The GetDBPath module determines where the database file is, then the second part to the code focus on the set sub-directory.

The complete code to change the background is triggered from an auto excuting macro as the database opens.

This all works find on my machine, everything performs as expected. However If I open the database from another computer, connected to the network I get an error. Upon investigation I found if I disable the code to set the background it works.

My understanding is that all the code to change the background is contained within the databse file, i.e there are no links to external files which may not be on other machines, and that as the image file for the background is on the network is accessable to all computers. (i have checked things like permissions etc, all allow access). All the other computers are also running Access97

I cannot understand why it will not open on other computers, can anyone advise?

 

[gemma-the-husky]

there may be something in the code at the top of the getdbpath module

try compiling it on one of the failing machines - that should identify where the issue is.

it may also be (but unlikely) some issue with the space in the folder path.