Error with opening a report in another database from within a form

[tontenn]

Hi Guys and espeically Remou.

The other day in thread thread702-1332179
you gave me a very easy and simple way to open up a report in another database from a form.

It worked well putting it through the system and on my pc, but on a couple of the networked computers, for some reason, once you click the button and the other database opens up, the form shows but an error message is present.

When i go into debug it highlights the line aapAccess.Visible = True.
It also then freezes the 2nd opened database and the only way to exit that is to cntrl alt delete and close down.

What i tried was to delete that line in the code. It made no difference on my machine, it still opened perfectly, but on the others it opened the other database and thre report but froze and would not let us show it or print it or anything.

I wonder if anyone else has had this issue and might be able to give me some advice.

Cheers

Tones

 

[Remou]

What is the error message? Can you open the second database by itself, that is, in the normal way?


Sometimes it is better to explain the problem, rather than ask for a solution.

 

[tontenn]

Hi Remou

Sorry for taking too long to get back to you. We have since had a major server overhaul and whatever was causing the issue has now been reolved.

Cheers
Tones