Error and locking when opening report from another database 1

[tontenn]

Hi Guys

Just a quick error question I hope someone can help me with.

In thread702-1332179 I asked a question about opening up a report from another database on the same server. Remou answered and supplied me with a great piece of code that has done the trick. Up until now.

Now when we try to click on the link and open the report on the other database it opens it up ok but then throws up an error message which says

"Run-time error 2455" You entered an expression that has an invalid reference to the property Visible.

It then allows me to debug or cancel but leaves the opened database in lock mode and all we can do is go to task manager and close it from there. Very annoying but also means we cant get to the report we need.

Hope someone understands the issue and has a suggestion.

Cheers in advance

Tones

 

[tontenn]

Hi PHV

Ok I have checked with the It guys and they have now just updated all the latest patches for office and access and still the contions box appears. Obviously this is the issue as the first time after the update we tried it, the box didnt appear and the database opened fine.

So I think i need some devine intervention from a microsoft guru now

 

[tontenn]

Hi

Found the solution to my problem at last in thread68-53433

It was all to do with installing office as administrator and then opening it the first time as a user.
I just went back in as administrator, accpeted the end user license agreement and it has fixed the issue of opening up the other database.

Thanks heaps for all your advice anyway

Tones